1 of 1 people found this helpful
This sounds like an odd case. I would recommend sending in a support request at:
If possible, send them the packaged workbook where you are seeing this behavior and provide as much information as possible.
As a possible workaround, a calculated field could be created to force HELOC to be all upper case, similar to the following:
if [Field]='Heloc' then upper([Field]) else [Field] end
Hope this helps!
This is definitely a thing. I will submit a support request.
Names are changed on extract to either all lower or all upper from title. Ken to KEN and Rick to rick.
Very interesting. I hadn't seen that specific error for a while now (that was 6.1.2). Are you seeing this in version 8?
Version 7.X, don't recall the exact version right now.
From additional searching it appears to be related to the collation/character set of the mysql database. Where-in Tableau is either trying to use a character set that the DB is not or cannot introspect to find the character set. It is definitely repeatable just haven't had time to dig deeper into it. That's the theory at least.
It is not consistent in how it applies the case changes. Same field, different records some get case changes some do not so that does cast some doubt on it being DB related. I would expect more consistent case changes if it was in fact the DB character set.