Separating Lists into new rows

hx @Aaron_Chupp , I am glad you tried out something.

This works:

Sequence(1,thisRow.[Line Items].Count()).FormulaMap([Helper Table (Line Items)].AddRow(
  
[Helper Table (Line Items)].[Example-Christiaan],thisRow.[Line Items].Nth(CurrentValue),[Helper Table (Line Items)].[Order Number],thisRow.[Order Number],
[Helper Table (Line Items)].TheName,thisRow.Name))

What you see is the application of a virtual index to distribute values living in one cell.

Enjoy your day, Christiaan

3 Likes