Hi Guys,
I am figuring out how to duplicate rows in Alteryx for different product group, would you please help to shred some lights? Thanks in advance.
So here's the original table (what I have), product name is the sub product name. Each sub product have different lines of data.
| Product Name | Data |
| X-1 | 1 |
| X-2 | 2 |
| X-2 | 3 |
| X-3 | 5 |
| X-3 | 6 |
| X-3 | 8 |
| Y-1 | 2 |
| Y-1 | 6 |
| Y-1 | 7 |
| Y-2 | 3 |
| Y-2 | 2 |
I would like to duplicate the rows into this table, all the product and sub product will see the same info.
| Product Name - Revised | Data |
| X | 1 |
| X | 2 |
| X | 3 |
| X | 5 |
| X | 6 |
| X | 8 |
| X-1 | 1 |
| X-1 | 2 |
| X-1 | 3 |
| X-1 | 5 |
| X-1 | 6 |
| X-1 | 8 |
| X-2 | 1 |
| X-2 | 2 |
| X-2 | 3 |
| X-2 | 5 |
| X-2 | 6 |
| X-2 | 8 |
| X-3 | 1 |
| X-3 | 2 |
| X-3 | 3 |
| X-3 | 5 |
| X-3 | 6 |
| X-3 | 8 |
| Y | 2 |
| Y | 6 |
| Y | 7 |
| Y | 3 |
| Y | 2 |
| Y-1 | 2 |
| Y-1 | 6 |
| Y-1 | 7 |
| Y-1 | 3 |
| Y-1 | 2 |
| Y-2 | 2 |
| Y-2 | 6 |
| Y-2 | 7 |
| Y-2 | 3 |
| Y-2 | 2 |
