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

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")