topic Re: How to duplicate rows when a condition is met in Alteryx Designer Desktop Discussions

How to duplicate rows when a condition is met

WCH — Wed, 17 Aug 2022 20:00:45 GMT

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

Re: How to duplicate rows when a condition is met

kathleenmonks — Wed, 17 Aug 2022 20:17:01 GMT

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?

Re: How to duplicate rows when a condition is met

binu_acs — Wed, 17 Aug 2022 22:16:25 GMT

@WCH one way of doing this

Re: How to duplicate rows when a condition is met

WCH — Mon, 22 Aug 2022 19:24:03 GMT

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