Forum Discussion
Power Query - Extract an Existing Column Name and put it in a new Custom Column
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.
Which column name? Short of you typing in the name of the column, how is the query supposed to determine which column's name to use?
Sorry, let's say we have Column A, ColumnB and Column C.
I want to make a new conditional column (D) that is filled with this text: "Column A"
Many thanks!
Viorel
Is there a function that extracts the name, something like Comun. Name ("Column A")?
I'm not sure why you would want to extract the text from the column header if you already are referring to the column by its name. Wouldn't you expect your hypothetical formula Column.Name("Column A") to return "Column A"? Why not just make a column that contains the text "Column A"? Why would you need to extract the same text you're already typing in?
I did this and it fills the new clumn with the content of the Column A (which I do not want) and not with the name of Column A (Which is "Column A").
I know this scenario seems stupid, but this is the format of a report that I have to transform :
I have multiple reports whose name of the first column "Column A" is the name of a Brand, so for each brand I have to do a transformation and the only place where I have the name of the Brand is in The name of the Column A, therefore I have to extract it dynamically.
Go to Add Column, hit the Custom Column button and in the formula box type
= "Column A"