Help required in Join keys
Re: Help required in Join keys
by tjegan » Mon Nov 03, 2014 12:02 pm
Thanks a ton. The above source is working fine
- tjegan
- Posts: 33
- Joined: Mon Mar 25, 2013 5:58 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Help required in Join keys
by tjegan » Fri Nov 07, 2014 7:11 pm
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.
Many thanks in advance.
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
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.
- tjegan
- Posts: 33
- Joined: Mon Mar 25, 2013 5:58 pm
- Has thanked: 0 time
- Been thanked: 0 time
Return to DFSORT/ICETOOL/ICEGENER
-
- Related topics
- Replies
- Views
- Last post
-
- Data required from both files depending on some keys
by Papya013 » Tue May 10, 2016 6:47 pm - 1 Replies
- 1528 Views
- Last post by BillyBoyo
Tue May 10, 2016 9:29 pm
- Data required from both files depending on some keys
-
- Join keys in SORT
by justin_thilak » Tue Aug 24, 2010 3:44 pm - 2 Replies
- 11211 Views
- Last post by justin_thilak
Wed Aug 25, 2010 6:15 pm
- Join keys in SORT
-
- Comparing 2 files using JOIN KEYS
by borneng2005 » Wed Jan 16, 2013 11:43 pm - 2 Replies
- 5229 Views
- Last post by borneng2005
Thu Jan 17, 2013 12:16 am
- Comparing 2 files using JOIN KEYS
-
- Join keys with matched values
by tjegan » Tue Nov 11, 2014 7:06 pm - 5 Replies
- 3480 Views
- Last post by Aki88
Mon Nov 17, 2014 12:06 pm
- Join keys with matched values
-
- SB37 abend in Join Keys
by ragsara » Wed Jan 21, 2015 9:26 am - 2 Replies
- 2618 Views
- Last post by Robert Sample
Wed Jan 21, 2015 6:17 pm
- SB37 abend in Join Keys