Facing the same issue in 8.3. Do we have any workarounds within Tableau for this?
Dealing with the exact same problem.
In my case, it will result in several hours of rework.
Is there an Idea for this?
Easily one of the most frustrating things I've dealt with in Tableau.
Column names should not be case sensitive.
This is one of those little times custom sql will step in to save you as you are able to alter the definition here.
Have you tried renaming the pills to the correct case? Not the best but still.
Good points but custom sql is not the solution when you have complex code in the database that should live there, not in Tableau.
Also fixing the pills in every single workbook that points to my data sources would take days!
I have created idea: http://community.tableau.com/ideas/4982
Please do not think I am suggesting that Custom SQL is the answer though in some circumstances, this may be of use.
Another alternative and indeed this might be the best would be to drop the workbook file .twb into Notepad++ and quickly alter the column sensitivity there instead.
Do make a copy first though.
Finally, if it is going to be too painful, could you not create a view or alias in your db to adjust the column names
Really appreciate your suggestions.
My point though is that Tableau has already spilled the milk.
The case of the columns was changed in the database.
At the next Tableau refresh, all of the hierarchies and folders were broken.
That is, the columns that used to be in a specific folder or hierarchy were not recognized any more so they were taken out of their folder/hierarchy.
The only way to fix this is to restore a backup, etc. This takes hours. Or to fix the data source manually, which takes hours too.
None of the solutions is easy.
And the problem doesn't need to be there in the first place.
We are also facing similar issues. If you find any idea or did a fix,kindly share your ideas.
Case sensitivity of the specific tables , what about aggregation tags and captions which is required to have capitals as per business view. Does this work ?
I just experienced this issue last week when I migrated a query from Oracle to Redshift and all data in Tableau disappeared. The exported file that Tableau was connecting to on our network drive, had lower case columns and Tableau was expecting uppercase. I found the following option in Redshift to set the columnnames to be uppercase, which resolved the issue.
set describe_field_name_in_uppercase to on;
Obviously this option may only work if you are exporting your result sets and may require a column name change if you are directly accessing the tables.
Hopefully there are similar options in SQL server to help you get the required output.