Forum Discussion

Goodkat's avatar
Goodkat
Icon for Helper II rankHelper II
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)
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
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)