read/write CSV boolean
Hello, I’m writing a CSV file that has a few columns with the boolean datatype.
The data is saved as 1’s and 0’s when written, as expected.
I’m reading this same CSV file in with a different workflow, however, the boolean option is not available for these columns in the transformation tab.
For some reason dates and small strings are available to change to boolean?
What is the requirement for reading a boolean column? And why are 1’s and 0’s not included if that’s how the CSV writer writes them?