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...
Need Help
  • 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.

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Hi PawelWrona, no need to use custom column. Use this as 3rd step of first table to create column name pairs.

Table.ToRows(#"Changed Type")

 

PawelWrona's avatar
PawelWrona
Icon for Resolver II rankResolver II
2 years ago

Thanks for the tip. Indeed, I haven't been using this functiong for a while..

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    2 years ago

    You're welcome. That's also the purpose of this forum - to learn 🙂