Copy columns from different files to same file

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.

Developer

Input

Output

Accepted answers

vizAlter

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

atcodedog05

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.

All comments

vizAlter

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

atcodedog05

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!

Pramod91

Hi @atcodedog05 ,

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703