Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
@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
@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.
@daez,please accept the solution the one which is correct and kudos also