Last Modified Date: 15 Jul 2019
- Tableau Prep 2018.2.1
- Text Files
Option 1Upgrade to Tableau Desktop 2018.2.2 or a newer version. See Tableau Desktop Downloads and Release Notes for downloads of current and previous versions of Tableau Desktop. For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.
- Connect to text file
- Click + button in the top left of the window and click + Add Step
- Navigate to the field where you would like to change the data type (Number Decimal, Number Whole, Date & Time, Date or String)
- Select the blue field data type icon in the top left corner of the box, and and select desired field data type
Option 3If an Excel file is used as a data source instead of a text file, the date can be changed to "string" before a step is added.
CauseThis behavior is related to a known issue (ID: 806084) which was fixed in Tableau Desktop 2018.2.2.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials