How to duplicate rows when a condition is met

Question

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 NameProduct CodeProduct LineAAA CDAAA CD111AAA CDAAA CD222AAA ZZAAA EF/GH333AAA ZZAAA EF/GH444

Desire:

Product NameProduct CodeProduct LineAAA CDAAA CD111AAA CDAAA CD222AAA ZZAAA EF333AAA ZZAAA EF444AAA ZZAAA GH333AAA ZZAAA GH444AAA ZZAAA EF111AAA ZZAAA GH111

WCH · Answer

@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.

binu_acs · Answer

@WCH one way of doing this

product_Code_0817.yxmd

kathleenmonks · Answer

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?

split_prod_code.yxmd