How to Duplicate Rows

DomoDave
DomoDave Member
in Magic ETL

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.

Tagged:

Best Answer

  • rco
    rco Domo Employee
    edited August 2024 Answer ✓

    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.

    Randall Oveson <randall.oveson@domo.com>

Answers

  • rco
    rco Domo Employee
    edited August 2024 Answer ✓

    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.

    Randall Oveson <randall.oveson@domo.com>

Categories