Forum Discussion

Arihant's avatar
Arihant
New Member
3 years ago
Solved

Column prefix

Hi, i am trying to add a prefix to a all my headers, basically i have Sales manager, Date, Amount, Profit etc, i want    1_Sales Manager 2_Date 3_Amount 4_Profit   The prefix would be combinat...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    =let a=Table.ColumnNames(PreviousStepName) in Table.RenameColumns(PreviousStepName,List.Transform(List.Positions(a),each {a{_},Text.From(_)&"_"&a{_}}))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

=let a=Table.ColumnNames(PreviousStepName) in Table.RenameColumns(PreviousStepName,List.Transform(List.Positions(a),each {a{_},Text.From(_)&"_"&a{_}}))