Merge two column from two differents files into one

[daez]

Hello everyone,

I have been struggling to solve my problem and didnt find a way on the forum. I have 2 files(maybe more after but I guess it will be done the same way), which have several columns. Here is what i would like to achieve : 

File A : 

Customer       Random_Info      Money

A                          xxxxxx             250

B                          xxxxxx             360

C                          xxxxxx             500

File B : 

Customer       Random_Info      Money

J                         xxxxxx             150

F                         xxxxxx             400

S                         xxxxxx             600

File required : 

Customer             Money

A                              250

B                              360

C                              500

J                               150

F                               400

S                              600

The column name might be different in the files tho( like one with "Customer "& the other one "Customer_name") , and there is no ID. All my Tmap & XMLmap jobs failed ... 

Thanks a lot for your help,

[daez]

@manodwhb, Thanks its working !!! So much easier !

i didnt understand how to use tuniqrow or tFiltercolumns to not have duplicate ... ? 

+ How can i choose which column i keep ?

Kindly

[manodwhb]

@daez,tUniquerow is the component to use the remove the duplicate values or pass the duplicate values to different output,that is not needed in your case.

[manodwhb]

@daez,please accept the solution the one which is correct and kudos also