Hello,
I've used Tableau Prep to read Data from a CSV to use it in Tableau Desktop.
That worked well until I noticed that the distance field is always 0, but in some rows there should be values.
(I think those fields are displayed as "None" in Tableau)
In the CSV the values are given in kilometers like the 0.009 km you see below.
Do you know what's wrong? :/
CSV. Prep- and TWBXFiles are attached.
Thank you very much!
7 answers
Hi,
No Excel conversion is necessary...because there are so many 0's for Distance in the first N rows Tableau Prep is interpreting the field as a whole number/integer. This is a screenshot from the Input step:
We can change that to a decimal and now the field in the Profile pane of a clean step shows all the values:
Jonathan
