Forum Discussion

Medmbchr's avatar
Medmbchr
Helper IV
3 years ago

Change columns name dynamically

Hi   I have many tables with codes as headers (ITMREF, ITMDESC) etc, and I have a 2-column Excel file in which I have the definition of each code (ITMREF = Item ID, ITMDESC = Item description).   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have a very similiar need.  At the moment I'm doing multiple steps like:

= Table.TransformColumnNames( PreviousStep, each Text.Replace( _, "OLDVALUE" , "New Value" ) )


Hopefully some wizard has a better solution

 

Medmbchr's avatar
Medmbchr
Helper IV
3 years ago

Hi Anonymous 

 

Thanks for your reply. I really can't use this solution since I have a very large data set: 50 tables and each have a minimum of 20 columns.

 

Let's hope someone figured out a solution.

 

Regards,