Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Renaming Table Headers with combined variable IDS as column headers with ID names from another table

I have two tables, Table 1 contains columns which are derived by combining two categories joined by underscore.  Table 2 have the identicle IDs with their text names.  I want to replace each ID wit...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank you all for the ideas shared, I appreciate it.
    I have managed to solve this by creating a lookup table with coded names and full-text names and then renaming the columns using Table.RenameColumns() function.