Forum Discussion
ViorelCa
Helper I
Helper IPower Query - Extract an Existing Column Name and put it in a new Custom Column
Dear Colleagues, I did not find a solution for a simple problem: Create a new custom column whose only content should be the name of an existing column in that Table. Many thanks! Viorel...
OK in that case your custom column's formula should be
= List.First(Table.ColumnNames(#"Insert Previous Step Here"))
...for whatever the previous step was. I'm going to guess it's #"Renamed Columns" or #"Changed Type" or something like that.
You must have typed
= [Column A]
That's not what I said to do.
= "Column A"
As for your scenario where you will have to extract the name of a column that you don't know the name of, I refer you to my original question. How is the query supposed to know which column to extract the name of if you can't refer to it by name?
Is it always literally the first column on the left that you want the name of?