Forum Discussion

Goodkat's avatar
Goodkat
Icon for Helper III rankHelper III
2 years ago
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...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    Use this as your next step

    = Table.TransformColumnNames(Quelle, (x)=>try mdTable[NewText]{List.PositionOf(mdTable[OldText], x, 0,Comparer.OrdinalIgnoreCase)} otherwise x)
Goodkat's avatar
Goodkat
Icon for Helper III rankHelper III
2 years ago

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