Forum Discussion

nelsonwhyu's avatar
nelsonwhyu
Frequent Visitor
6 years ago
Solved

Concatenate Dynamic COlumn

Hi, I am trying to create a new Column "Key" by concatenating every column with header starting with "Level ". However, number of Levels are dynamic and varies across my source files.  Lev...
Need Help
  • artemus's avatar
    artemus
    6 years ago
    = Table.AddColumn(Source, "Key2", each Text.Combine( List.Transform(Level_List, (col) => Record.Field(_, col)), "__")  )
artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
= Table.AddColumn(Source, "Key2", each Text.Combine( List.Transform(Level_List, (col) => Record.Field(_, col)), "__")  )
nelsonwhyu's avatar
nelsonwhyu
Frequent Visitor
6 years ago

Thanks artemus ! This works like magic

  • artemus's avatar
    artemus
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    Glad it works for you.

     

    Is there some part of this formula that you don't understand?

    • nelsonwhyu's avatar
      nelsonwhyu
      Frequent Visitor
      6 years ago

      artemus , thanks it's very helpful. The formula all makes sense.

      I think I just need to get more fluent in the usage/meaning of "each" and  "_"  notation