Forum Discussion
Solved
how to dynamically replace values for multiple columns
In power query, I previously split columns by a delimiter, so some of the columns in my query start the same "mt" with variations like "mt1" "mt2" mt3" etc. Each "mt" column is datatype text and has ...
Hi vc25
Using a demo structure, I have tried to replicate the solution to the query you've asked for.
This is considering you have a "Reference" Table matching the Numbers popping up to it's respective countries that you wish to replace in the column names.
This solution is predominantly about finding the number of delimiters present and using that count, frame the number of columns with the desired name.
I'll leave the excel file below for your reference. Please let me know in case of any queries or if this wasn't what you were looking for. Thanks!
Regards,
I can not see your steps or code
