Use case: I needed to append a count number to systematically generated rows after bursting/producing multiple lines from one row.
To provide more context, here is an example of the requirement:
I have a list of shows and I need to break out the list of shows to a lower level of detail, i.e. by episodes. However, from the original text, I need to add Episode count at the end of each show name.
INPUT DATA:
Show Name # of Episodes
Stranger Things: Season 1 8
Stranger Things: Season 2 9
OUTPUT DATA:
Show Name
Stranger Things: Season 1, Episode 1
Stranger Things: Season 1, Episode 2
Stranger Things: Season 1, Episode 3
Stranger Things: Season 1, Episode 4
Stranger Things: Season 1, Episode 5
Stranger Things: Season 1, Episode 6
Stranger Things: Season 1, Episode 7
Stranger Things: Season 1, Episode 8
Stranger Things: Season 2, Episode 1
Stranger Things: Season 2, Episode 2
Stranger Things: Season 2, Episode 3
Stranger Things: Season 2, Episode 4
Stranger Things: Season 2, Episode 5
Stranger Things: Season 2, Episode 6
Stranger Things: Season 2, Episode 7
Stranger Things: Season 2, Episode 8
Stranger Things: Season 2, Episode 9
I previously asked for advice/help on how to "burst" each row from my input data into lower level of detail by using a variable, in my example above, the episode count, and was helped here:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-burst-produce-multiple-lines-of-a-data-row-using-a/m-p/925359#M226265
