1 Reply Latest reply on Dec 13, 2013 2:01 PM by Tracy Rodgers

    Alias column name with a dictionary

    Xiaoming Zhu

      Tableau provides a nice way to enable user to alias variable names, via UI.  Are there ways to alias names based on a dictionary mapping?

      A use case is data are stored in a fixed data warehouse schema, where it has a TOTAL column denoting an aggregated measure with a special meaning for different departments.   For example, for purchase department it means Spend and for HR it means Employee Count.   When we create a report, we want to name it based on the department a viewer is associated with, i.e., Spend for Purchase and Count for HR.   If there are only a few departments, we can use UI to achieve the objective.  But if there are many, and especially when they change with time, it would be ideal to create a separate database table for a dictionary mapping of (TOTAL, Department_ID)=>Real Name for tableau reporting to pick up.  Does Tableau supports such a feature ?