conditionally copy and insert rows

[OJet]

Hi Alteryx  Gurus, 

Would you have an idea how to accomplish  a task like this: 

Input data:

a	0
b	2
c	0
d	0
b	0
e	1
f	0
b	0
e	0

Needed output:

a	0
b	2
c	0
d	0
b	0
c	0
d	0
e	1
f	0
b	0
c	0
d	0
e	0
f	0

Because number 2 corresponds to letter b, the next two rows of data need to be copied and inserted underneath each occurrence of b. 

In the whole dataset, no matter how many times b would be listed - only one case might have a corresponding number other than 0, so no conflict with different values of b is expected. Same concept for e: because corresponding number is 1 - the following 1 record needs to be inserted underneath each occurrence of e

Can something like this be solved with Alteryx?

Thank you!

[ArtApa · Accepted solution]

Hi @OJet - Here is how you can do this:

[Tyro_abc]

hi

This is my version. I am sure this can be simplified. 

Regards

Arundhuti

[OJet]

@Tyro_abc , @ArtApa  Thanks a lot to both of you, great solutions and  I learned a lot by looking at how you approached this