Forum Discussion

Mitsugu's avatar
Mitsugu
Regular Visitor
3 years ago
Solved

Expand each table dynamically from list, using list sequence as equivalence for like columns

I'm looking for a command similar to the Table.ExpandTableColumn() with a change to the required column extraction for each table.       = Table.ExpandTableColumn(Source, "ColumntoExpand",...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    then transform the custom column firstly, then click to expand it.

    NewStep=Table.CombineColumns(PreviousStepName,{"Custom","List"},each Table.Skip(Table.DemoteHeaders(Table.SelectColumns(_{0},_{1}))),"Custom")

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=Table.FromColumns(List.Zip(List.TransformMany(Table.ToRecords(PreviousStepName),each Table.ToRows(Table.SelectColumns([Custom],[List])),(x,y)=>y)))

Mitsugu's avatar
Mitsugu
Regular Visitor
3 years ago

Thank you so much, it works great!

I did notice though that the formula only looks at the [Custom] column and doesn't retain any of the information from the other columns. Is there a way to retain that information while expanding the tables?

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    then transform the custom column firstly, then click to expand it.

    NewStep=Table.CombineColumns(PreviousStepName,{"Custom","List"},each Table.Skip(Table.DemoteHeaders(Table.SelectColumns(_{0},_{1}))),"Custom")

    • Mitsugu's avatar
      Mitsugu
      Regular Visitor
      3 years ago

      Thanks Daniel!

      Took me a while to get but I got your formula working now~

       

      = Table.CombineColumns(SourcetoExpand2,{"Custom", "List"},each Table.Skip(Table.DemoteHeaders(Table.SelectColumns(_{0},_{1})), 1),"Custom")