How to duplicate rows with in order to see same information across product and subproduct.

[WCH]

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

[DannyS]

Hi @WCH ,

See attached workflow and let me know if this is what you are looking for. I had to do some multi-row formulas for the Y records because the append fields was causing some extras duplicates ("dup"), so needed to remove those.

Hopefully this helps!

[DavidP]

Hi @WCH 

Have a look if this workflow does what you're looking for

[JWS · Accepted solution]

@WCH take a look at this workflow.

[WCH]

you guys are so brilliant !!!

I pick your solution as it is very similar to mine.  I was keep digging how to use the Generate Rows APP, and finally it turns out this could all be solved without it! Excellent!!!!