Multi-Row formula for serial numbers

[jpeyros]

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

[jdunkerley79 · Accepted solution]

Easiest way to do this is to use a generate rows tool to do this.

Sample attached

[jpeyros]

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