Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHad the same solution as most others with the generate rows, however, added an additional solution of using the Advance Join Macro as if I was joining using millions of rows, It would inflate the data.
Used a Cross Join
Generate Rows is a fantastic tool that I didn't discover until I'd been using Alteryx for several months. :-)