How to Duplicate Rows

DomoDave

I have a dataset that represents order information. Each row is a unique order ID. One of the column values shows the quantity. I would like to duplicate (or replicate) the rows based on the value in the quantity field.

Example OrderID 12345 has a Quantity value of 5, so in the output dataset, I want 5 replicated rows for OrderID 12345.

rco

This will be easier in the near future with the Join tile ON clause and the Series (row generator) tile. For now, the solution to this problem is described here. There's more than one answer; the more complicated one involves generating a series table within the flow, the simpler ones assume you've built a series table as a DataSet in Domo with Webforms or a file upload.