4 Replies Latest reply on Mar 22, 2018 3:38 AM by Jan Horcicka

    Text file data source - missing string values in a list of numbers

    Jan Horcicka

      I have a text file as a data source. One of the data source columns contains values that are in most cases numbers, but sometimes there can be also a text (example: 1000PR). The problem is that when there is a value with a text, the whole value is missing in the Tableau.

      I suppose it's a formatting problem. Tableau thinks the whole column is numerical and doesn't know how to handle the text.

       

      Is there a way to solve this issue? Changing the formatting for this column in the Tableau data source didn't work, since the data is already missing at this point.