We are using Tableau 2022. We have this Portuguese Dashboard that has DB source as custom SQL. We now need to translate that Dashboard into Italian. So We now need to have SQL code to use the Italian field names (that contains the Italian data) for this newly created italian version.
QUESTION : Is it a better practices to have another query with all the new italian column names in it's sql code for this new Italian dashboard or we should instead APPEND the newly created sql code referring to these new italian columns all in the same query that already has the portuguese column names ? Or is there a better way to do this ?
Thank you.
If the both data sources have same fields and dashboard is complex and you want to avoid redo/validation efforts on calculated fields, filters etc .
I'd edit the custom sql so that it would return exactly same field names for to tableau to use.
In custom sql
Old: SELECT portugese_field_name....
New: SELECT italian_field_name AS portugese_field_name...
Then on tableau user interface i would rename only the visible fields to italian.