Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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 combination of series of number from 1 and with delimeter "-" with the orginal text.
Please let me what would be the possible solution to it, TIA
Solved! Go to Solution.
=let a=Table.ColumnNames(PreviousStepName) in Table.RenameColumns(PreviousStepName,List.Transform(List.Positions(a),each {a{_},Text.From(_)&"_"&a{_}}))
=let a=Table.ColumnNames(PreviousStepName) in Table.RenameColumns(PreviousStepName,List.Transform(List.Positions(a),each {a{_},Text.From(_)&"_"&a{_}}))
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 11 | |
| 7 | |
| 6 |