Unable To Change Data Type Of Multiple Fields In Bulk

KNOWLEDGE BASE

Published: 12 Dec 2019
Last Modified Date: 08 Jul 2022

Tableau Prep Builder automatically assigns certain data type of fields when connecting to a text file and unable to change them in bulk.

Possible workaround:
Option 1: Open the text file by Tableau Desktop with schema.ini, then extract data.

Create schema.ini to define data types of columns in a text file.
For more details about schema.ini, see Create a schema.ini File.
Open the text file by Tableau Desktop.
Extract data and saved as a hyper file.
Open the hyper file by Tableau Prep Builder.

Option 2: Use a database which allows to define data type of columns at the data source side instead of the text file.