Dear Alteryx-enthusiast,
I'd like to ask if there are any ways to generate predefined number of rows (e.g. in this example below: 3) for every unpredefined number of (distinct) input value?
Hope the picture below clearly describes my goal.
I've tried to use Generate Rows / Multi-Row / Multi-Field formula and been digging through many alteryx discussions but haven't found any similar case to mine yet.
I also don't wish to use Macro as this case above is just a small part of my total workflow and would increase complexity...
Thank you very much for any recommendation.
Solved! Go to Solution.
Hello @ngthuyduong93 - you can accomplish this using the Generate Rows and Append tools. Attached is an example workflow.
Wow, thank you all very much for the super fast response 👍
The solution are also very neat and much simpler than I thought.
Really appreciate all the help from you guys.