1 of 1 people found this helpful
I've just tried to replicate this and I think the issue is with the collation sequence of the source data in Excel - not the extract engine. Normally Tableau infers the collation sequence (i.e.settings like character set and case sensitivity) from the source - but it looks like Excel isn't providing the details to Tableau.
I've created a simple excel file like yours:
Client Name Client ID John ab Mary Ab Suzie AB
I then connected Tableau to it and get some inconsistent results of case depending on the order of the columns:
In one query the case is sensitive, but not in the other.
I'm sure there must be a way to set case sensitivity in the connection file or the preferences - I can't find it right now but I'll keep looking.
UPDATE: I can't find a setting anywhere for this in Tableau. I've tried formatting the Excel file and setting the encoding on the document to Unicode, ASCII, UTF and no joy. Anyone else have any ideas? Perhaps log it with Support Message was edited by: Peter Hopwood
Thanks, Peter. We could still not figure out how to get the IDs recognized consistently regardless of case sensitivity so we developed a workaround...basically assigned each client a new ID that was not case sensitive. Not very elegant, but effective.