ExtMergeJoin proble;

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Selrahc
Posts: 1
Joined: Wed Aug 05, 2015 2:07 am

ExtMergeJoin proble;

Postby Selrahc » Wed Aug 05, 2015 2:45 am

Hi All,

I have 3 files

File #1 format : ID|Name
23|Robert
37|Marcel

File #2 format : ID|Phone Type|Number
23|fixe|445
23|mobile|923
37|mobile|764

File #3 format : ID|Address
23|Address1
23|Address2
23|Address3
37|AddressZ
37|AddressY

And I would like to have this in output :

Output format : ID|Name|Phone Type|Number|Address
23|Robert|fixe|445|Address1
||mobile|923|Address2
||||Address3
37|Marcel|mobile|764|AddressZ
||||AddressY

How can I do that ?

Thank you

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: ExtMergeJoin proble;

Postby slechtaj » Fri Aug 07, 2015 3:53 pm

Hi Selrahc,

I went through your task and I'm not sure I got the idea as it seems you want to use only one key to join three tables. That is strange actually, since it is not clear from it what address is supposed to be joined with a particular phone number. It appears to be joined using the only ID and the rest is randomly picked. Is there anything else that helps you decide how to join Phone data and Address data?
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support


cron