Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Generate predefined number of rows for dynamic n distinct input value

ngthuyduong93
5 - Atom

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. 

ngthuyduong93_1-1639659769032.png

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.

 

3 REPLIES 3
MatthewO
Alteryx
Alteryx

Hello @ngthuyduong93 - you can accomplish this using the Generate Rows and Append tools. Attached is an example workflow.

MatthewO_0-1639665924916.png

 

csmith11
11 - Bolide

Slight different solution as well:

 

csmith11_0-1639673071927.png

 

ngthuyduong93
5 - Atom

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.

Labels