Separating Lists into new rows

6

hi @Nikki_Donkin

Thanks for the doc, that helps indeed :wink:

What I did it checking the columns to see how many items they contained and most of them only 1 instead of the 10 you see To keep it simple I duplicated each column and created a split version (could also be done in the code in the button, but as such you see better what happens). In the button I refer to this split version.

I left the ‘test’ out

Sequence(1, thisRow.[Order Number].split(",").Count())
  .FormulaMap(
    Addrow(
      [Orders Separated],
      [Orders Separated].[Line Item],thisRow.[Line Items Split].Nth(CurrentValue),
      [Orders Separated].Order,
      thisRow.[Order Number Split].Nth(CurrentValue),
            [Orders Separated].SKU,
      thisRow.[SKU Split].Nth(CurrentValue),
      [Orders Separated].Quantity,
      thisRow.[Volume Split].Nth(CurrentValue)
    )
  )

image
image2001×734 95 KB

Does this work for you?

Best, Christiaan

3 Likes