Last Modified Date: 10 Oct 2018
- Tableau Desktop 2018.1
- Windows 10
- Text Files with time-only string values in a column
ResolutionThis behaviort is currently by design.
There are three potential workarounds:
- Save the data in Excel and save it as an xlsx file instead, then the union will work as expected.
- Create a calculated field using the DATEPART() function, which can be used to isolate the time portions of the field after the union. See the following documentation from our Online Help for more infomration: Date Functions
- Use manual unions rather than wildcard unions.
CauseTableau Desktop does not have a "time-only" data type. The time values in the data are therefore converted to the default "date-time" data type. This change is done automatically, when the wildcard union is compiled and the underlying time-only values are lost.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials