Forum Discussion

fmdf's avatar
fmdf
New Contributor III
5 years ago

Bit is converted to 'true' and 'false'

Everytime I pull data from SQL Server / Salesforce etc, if the data type is bit, it returns a string of ‘true’ or ‘false’ that I am then having to convert back to a 0 or 1. How do I get this to beh...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
5 years ago

Hi @fmdf ,

I can think of two solutions:

  1. You can cast the value while reading in your query => SELECT CAST(field AS int)
  2. Use a Mapper with a ternary operator within SnapLogic => $field == ‘true’ ? 1 : 0

Regards,
Bojan