I have some fields with data type “bit” in my data sources. In the new data prep experience, I am unable to use these fields for a filter - they simply aren’t selectable (with no visual indicator of any problem). I am also unable to change the data type - the drop down appears empty. Is there any way I can use my data without bringing all tables with Boolean fields in using custom SQL so I can convert to a string or an integer?
Hi @ncatlett
Welcome to the Quick community!
Try converting them using Custom SQL in your dataset query. Here are examples correct the syntax based on your database compatibility.
Example:
Boolean to String:
CAST((CASE WHEN BitColumn = 1 THEN 'True' ELSE 'False' END) AS VARCHAR) AS BitColumnStr
Boolean to Integer:
CAST(BitColumn AS INT) AS BitColumnInt
Hi @ncatlett,
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Thank you
Hi @ncatlett,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you