How to duplicate rows when a condition is met

[WCH]

Hi Guys, 

Thank you in advance for helping me with this.  I am trying to convert the existing table to the desire one

so the request is 1)product code AAA EF/GH is combined in one line, and I need to split them out

                            2) When Product Line = 111,  need to generate the same record for product AAA EF & AAA GH as well.

is there any simply workflow to do this?

Existing:

Product Name	Product Code	Product Line
AAA CD	AAA CD	111
AAA CD	AAA CD	222
AAA ZZ	AAA EF/GH	333
AAA ZZ	AAA EF/GH	444

Desire:

Product Name	Product Code	Product Line
AAA CD	AAA CD	111
AAA CD	AAA CD	222
AAA ZZ	AAA EF	333
AAA ZZ	AAA EF	444
AAA ZZ	AAA GH	333
AAA ZZ	AAA GH	444
AAA ZZ	AAA EF	111
AAA ZZ	AAA GH	111

[kathleenmonks]

Hi @WCH,

For your first problem, see my attached solution and screenshot. I first parse out the different product codes, then transpose the data and filter out null values. 

As for your second problem, do you have another file you can join that would list the product lines that need to be duplicated for EF and GH?

[binu_acs]

@WCH one way of doing this

[WCH]

@binu_acs I like this solution, very direct and simple. Just one quick question, in the setting of app Generate Rows, do I put whatever number of rows I want to generate, cuz actually it is a long file, I think maybe 2000 rows. now sure if the work flow would still works in that way. I need to test it out.