Hello to you, data experts,
I am new to Alteryx and I am having an issue regarding the creation of a serial number file.
Now I have the data shaped as intervals, just like so :
Product | Language | Start | End |
XXX | English | 1 | 10 |
ZZZ | English | 11 | 15 |
YYY | English | 16 | 18 |
But what I would need is something like this :
Product | Language | Serial number |
XXX | English | 1 |
XXX | English | 2 |
XXX | English | 3 |
XXX | English | 4 |
XXX | English | 5 |
XXX | English | 6 |
XXX | English | 7 |
XXX | English | 8 |
XXX | English | 9 |
XXX | English | 10 |
ZZZ | English | 11 |
ZZZ | English | 12 |
ZZZ | English | 13 |
ZZZ | English | 14 |
ZZZ | English | 15 |
YYY | English | 16 |
YYY | English | 17 |
I have been playing around the Multi Formula tool but without "luck" yet. I think expertise is what I need.
Can someone help please?
Many thanks,
MP
Solved! Go to Solution.
You're the man, jdunkerley!
Thanks a million,
I will use your solution to understand your logic and why it works here.
Have a great day