Magic ETL

Magic ETL

How to Duplicate Rows

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

  • 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

  • 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>

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In