Forum Discussion
bojanvelevski
5 years agoValued Contributor
Hi @fmdf ,
I can think of two solutions:
- You can cast the value while reading in your query => SELECT CAST(
field
AS int) - Use a Mapper with a ternary operator within SnapLogic => $field == ‘true’ ? 1 : 0
Regards,
Bojan
Thank you for the suggestions.
I am doing the mapper solution now.
Why should I have to cast a field as int when it is already a bit and therefore not string?
I don’t really want to do either of these options but it seems I have no choice.
I just want them to stop converting my bit data to a string. If they can’t handle bit, at least automate it to int instead of a string.
It creates extra work for me with the “no code” solution (rolling eyes).