Page 2 of 2

Re: Help required in Join keys

PostPosted: Mon Nov 03, 2014 12:02 pm
by tjegan
Thanks a ton. The above source is working fine :)

Re: Help required in Join keys

PostPosted: Fri Nov 07, 2014 7:11 pm
by tjegan
The above control statement works fine if the input file1 contains the duplicate value. Could you please share me the control card if
input file2 also contains the duplicate value.

When i try with the above control statement, i am getting the below output.
Input File1
1000 ARUN A
1001 BALA B
1001 BALA D
1001 AAAA D
1001 BBBB D
1007 CHAN C

Input file2:
1001 BALA 1     
1003 KATE 2     
1001 JOHN 5     
1004 EDWIN 3     

Output:
1001 BALA B 
1001 BALA 1 
1001 BALA B 
1001 BALA D 
1001 BALA D 
1001 AAAA D 
1001 AAAA D 
1001 BBBB D 
1001 BBBB D 

Expected output:
1001 BALA B
1001 BALA D
1001 AAAA D
1001 BBBB D
1001 BALA 1     
1001 JOHN 5     


Many thanks in advance.