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
Logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.