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!
Solved! Go to Solution.