Expand Qty Field Into Multiple Rows (De-aggregate)

Dion_McCormick · November 2, 2021, 4:49pm

I have a file that has incoming order data. The file has a product number and qty field.

Product, Qty
Product A, 2
Product B, 3

I would like to take each row and “expand” or De-Aggregate into individuals rows.
Product A, 1
Product A, 1
Product B, 1
Product B, 1
Product B, 1

Essentially the opposite fo the Aggregate function.

Any tips? Thanks in advance.

dgudkov · November 2, 2021, 5:16pm

Hi Dion and welcome to the Community!

You can use the “Repeat rows” action to insert rows. Then simply replace values in the column with counters with 1. See the example below:

Dion_McCormick · November 2, 2021, 5:51pm

Wow. You are amazing. That is perfect!!!