community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Generate a set number of rows for each cell in one column

Highlighted

Hi all

 

I have my two (2) inputs data in the below format, I would like to combined the two data sets by generating the same rows based on Input 2 for each data point in Input 1.

 

Is there a way to achieve this at all??

 

 

INPUT 1 INPUT 2
1001 A
1002 B
1003 C
  D
   
   
Desired Output 
1001A 
1001B 
1001C 
1001D 
1002A 
1002B 
1002C 
1002D 
1003A 
1003B 
1003C 
1003D 

 

 

Thanks!

Gundam

Alteryx Certified Partner

Hi @gundam_pilot,

 

You can achieve the same using append tool.

 

Thanks,

Vishwa

Use an Append Fields tool.

 

If you have a large second set then you will need to tell it to Allow All Appends, as by default it errors at:

2017-10-05_07-40-29.jpg

 

Sample attached

Labels