8 Replies Latest reply on Jan 18, 2017 12:58 PM by NAVEEN KUMAR

    How to automate renaming or aliasing column names

    NAVEEN KUMAR

      I have a fact with more than 100 columns. The column names are meaningless. I have the corresponding meaningful names with me in a sheet(Can load it in a table as well). How can I replace the meaningless column names with the names that I have with me in a sheet/table? I'm using tableau 10.0 on Hive

       

      Fact table:

       

      Time 123 456 789

      ------ ----- ----  ----

      abc   nsn  nss jjjjj

      ajdj  jsdjd jsjsj jksk

      ajsh jsjjkk ksd nndj

       

      I have this with me:

       

      123 Column_a

      456 Column_b

      789 Column_c

       

      I need like this

       

      Time Column_a Column_b Column_c

      ------      -----           ----              ----

      abc        nsn            nss             jjjjj

      ajdj       jsdjd           jsjsj             jksk

      ajsh     jsjjkk            ksd              nndj

       

      Please don't mind the values in the table. Thanks very much.

      NAVEEN