Copy columns from different files to same file

[Savannah]

I have 19 columns from File1 and 1 column from File2 I want to put in the same sheet. 

When i try to use Union Tool and I have 

Output Order / Set a Specific Output Order - ticked, it'll take the column from File2 and correctly put it in the 20th column, however put it several hundred rows below the last row in File1. 

I just want the column from File2 to be next to the other columns in File1. 

Any suggestions are much appreciated. 

[vizAlter · Accepted solution]

Hi @Savannah — Then, try to use a "JOIN" tool, and join by Record Position

[atcodedog05 · Accepted solution]

Hi @Savannah ,

I think this might the you are looking for 

Use join tool and set option  as Join by position

If this is not what you are looking for please give me more description and files i can help you out.

Hope this helps : )

If this helps please mark the post as solution.

[Savannah]

Hi!

Thanks for such a quick reply! 

It worked! Thanks a lot! 

[Savannah]

Hi!

Thanks for such a quick reply! 

It solved it! Many thanks!

[vizAlter]

@Savannah — Thank you!

[atcodedog05]

Happy to help : ) @Savannah 

[Pramod91]

Hi @atcodedog05 ,

How to do this if I want to add columns from more than two inputs to one output?

[atcodedog05]

Hi @Pramod91 

You can use Join Multiple Tool.

Workflow:

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍