Forum Discussion

ViorelCa's avatar
ViorelCa
Icon for Helper I rankHelper I
8 years ago
Solved

Power 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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

That still doesn't answer my question. If you can't refer to it by name, how do you know which column to use? Is it literally the first column on the left? Is it always the third? Could it change positions based on which report you're in?

ViorelCa's avatar
ViorelCa
Icon for Helper I rankHelper I
8 years ago

It is always the first column, and after I get its name (the name of the Brand) I will change it with the proper name (P&L Category), therefore in the new Custom Column I have to remain with the name of the Brand.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

  • ViorelCa's avatar
    ViorelCa
    Icon for Helper I rankHelper I
    8 years ago

    Many thanks, Anonymous , it works like a charm!

     

    I remain indebted to you!

     

    Kind regards,

    Viorel