Hi Chithra Rahul,
Not sure what you mean by case sensitivity in tableau but I can give one example if you have datasource field name "COMPANY" and you create a calculated field name "company" it won't stop you to do so and it will create two different fields
Hope this answer your query
Vishal R. Shukla
when we try to replace connection in-case of having same column names but not cases of fields then tableau mark it as invalid column. Renaming column or creating calculated fields needs some manual works. If it for one or two reports its fine. But for more number of reports what would be best way ?
copying from tableau kb article:
When you are using Microsoft Excel data sources, Tableau Desktop treats the data in a case-insensitive manner. For example, field names Sales and sales will be read by Tableau Desktop as the same field.
Could you please tell us what data source you're using?
I am using MYSQL and redshift (case -insensitive).
This is what i was say that tableau is case sensitive suppose your current data source have
field name as "Company" and and new datasource(which will replace the current) have name "company" this will be a different field
in your case if you have data source on tableau server i would suggest make change (like rename the fields in any one case in the datasource once and then replace the server copy with new one
Thanks Vishal. I am also thinking to do in that way. So we need manual works for one set. But in my case one set has more number of workbooks which consumes time.
As far as I understood, you have two options, edit the alias on back end or edit the alias on front end (Tableau). In either case, unfortunately there is manual work to do. Based on your data structure, you would have to decide which would take less time.