Merge two files

[Gsiva3]

Hi Team,

Hi @Qiu 

I have two inputs with different number of columns. In input 1 the columns are A,B,C,D,E,F,G,H and in input 2 the columns are A,B,C,D,E. Now my requirement is that, the columns A,B,C,D,E are same in both input 1 and input 2. Now what I want is, I need to copy the column H from input 1 to input 2. So that my output contains columns A,B,C,D,E,H.

Is this possible. If so please help me on this.

I have attached the sample file.

[Emil_Kos]

Hi @Gsiva3,

I think you can use join tool:

The output:

You can easily rename the column names by clicking clear all renames in the join tool:

[echuong1]

Your use case is simply a Join. Connect both inputs and use the drop downs to select the fields that should match. It will automatically use all of the fields from both inputs. I unchecked the unwanted fields.

[Qiu]

@Gsiva3 
Thank you for mentioning me, and sorry for being late.

@echuong1 and @Emil_Kos  have already given excellent answers.