Logic

[iwin]

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

[ray.wurlod]

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.