ExtMergeJoin proble;

selrahc

• August 05, 2015 00:00

• Answered

Follow

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

  • August 07, 2015 14:53

  0

  Comment actions Permalink

  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?

Please sign in to leave a comment.