Forum Discussion
Solved
Case insensitive column rename with mapping table
Dear friends of Power Query, With the help of the forum, and two insightful websites (a big, big thank you to Imke Feldman thebiccountant.com and Rick de Groot gorilla.bi) I was able to further i...
Use this as your next step
= Table.TransformColumnNames(Quelle, (x)=>try mdTable[NewText]{List.PositionOf(mdTable[OldText], x, 0,Comparer.OrdinalIgnoreCase)} otherwise x)
Dear Vijay,
it works perfect. Brilliant! I have never seen the 'try' / 'otherwise' commands before!
Good learning! And the headers are now as they are supposed to.
Thank you so much!
Best regards, Andreas