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

Alteryx designer Discussions

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

Join multiple files with similar row items and append all columns from the files

Atom

Hi all 

 

I am new to this tool. 

I want to add multiple files with the first column header same in all files but different column headers. Please find the below sample data, I created. 

Input 1 

Type      Header 1
R1            20
R2            40
R3            50
R4            10

Input 2

Type       Header 2
R2             60
R4             30


Output 
Type      Header 1      Header 2
R1            20                  0/null
R2            40                    60
R3            50                  0/null
R4            10                    30


Thanks in advance

Alteryx Certified Partner

@RZ

 

You can use the Join tool if you only have 2 files. If there are more than 2 files you'd like to join, use Join Multiple tool to achieve that. I have attached a solution to this reply for your review.

Atom

I tried this but I got errors earlier and I figured that there is some option one should take which is "accept all multi dimensional fields to join". 

Thanks 

Labels