DSXchange

Hi All,
I have 3 different links with different column names but all have cust_id as key column and i have to merge them.

INPUT:

Source link1:
Cust_id
Col1
Col2

Source link2:
Cust_id
Col3
Col4

source link3:
Cust_id
Col5


OUTPUT:

Target Link:
Cust_id
Col1
Col2
Col3
Col4
Col5
Col6


The data can come from all the links or any link. Any suggestions how to do it. I tried to use look-up and merge stage but it doesnt work. One of the issue is how to pull the correct cust-id from the link where data come in.

Thanks for Any suggestion

Join stage would seem to be what you need. Either one Join stage with three inputs or two cascaded two-input Join stages. Include a source indicator (such as file name) in a full outer join so that you know from which source the row came.