Can we do Join Pair and Unpair on different key flds
Posted: Tue Jul 17, 2012 7:43 pm
Hi All
Can we do Join Pair and Unpair on different key flds in single Sort step ?
I have 2 files ,file1 & file2 .I need to Pair 2 files for the based on 2 different key fields .The O/p should have record from 2nd file which is matched on first field (fld1) and not matched on second field(fld2).
If I have to match on first and second field,My output should be AAAA KKKK (from FIle 2).For the first record in file2,the 2 files match on first field but not matched on second field.
I have searched and I could see we have different syntax for Pair and Unpair on same key field.But I could n ot find it on different key field.
Can you please let me know if this is possible using joins?
Can we do Join Pair and Unpair on different key flds in single Sort step ?
I have 2 files ,file1 & file2 .I need to Pair 2 files for the based on 2 different key fields .The O/p should have record from 2nd file which is matched on first field (fld1) and not matched on second field(fld2).
File 1:
fld 1 fld2
---------------
AAAA ZZZZ
BBBBB YYYY
CCCC XXXXX
File 2:
fld 1 fld2
---------------
AAAA KKKK
BBBBB YYYY
DDDD XXXXX
If I have to match on first and second field,My output should be AAAA KKKK (from FIle 2).For the first record in file2,the 2 files match on first field but not matched on second field.
I have searched and I could see we have different syntax for Pair and Unpair on same key field.But I could n ot find it on different key field.
Can you please let me know if this is possible using joins?