1 of 1 people found this helpful
Hmm, interesting! I hadn't known that Tableau trims Excel input during the load. Can you edit the data source to use some character other than a space to indicate the difference between the two descriptions?
2 of 2 people found this helpful
This is an odd one. There are a couple of possible approaches:
1. Adjust the data in Excel, either using David Li's suggestion, or using some of the calculations you have above to determine which is which.
With the legacy connection, you'll still see Tableau trim the field when you use, but you can use a calculated field with LEN([Field]) to get the different lengths:
(it collapses to the trimmed value)
(the lengths are different)
And that let's you split out the distinct values you want (you can hide the headers for Length if desired).
Anyways, a strange work-around, but maybe something you can use.
Hope it helps!
Thank you Joshua!!
Your response has been very helpful.
Thank you David for your help!!