Hello - I am trying to create a workflow in Tableau Prep 2018.2 .The workflow pulls data from a table within a database ,does some transformation and publishes the dataset to tableau server. There are certain fields within the table which have value of either 0 or 1. I want to change the datatype of these fields to Boolean.
Would someone know if it can be done in tableau prep 2018.2. I do not want to create a calculated field which assigns value of True/False depending on the value of these fields.
You can Create a Calculated field which would create a new Column
If Your Field<>0 Then "T" ELSE"F" END
Try This Too