View previous topic :: View next topic
|
Author |
Message |
Nitin Goel
New User
Joined: 21 Aug 2013 Posts: 2 Location: India
|
|
|
|
I am trying to achieve the following functionality using ICETOOL. I have two input files.
File 1
11111
22222
33333
44444
77777
File 2
22222
33333
44444
55555
66666
Output file
55555
66666
I want to get all of the records which are there in File 2 but not in File 1, I have tried several options but not able to get the desired results.
Can somebody help me with this, Thanks. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
For this, forget ICETOOL.
It is a simple JOINKEYS with SORT, with JOIN UNPAIRED,F1,ONLY |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Bill, should that not be F2,ONLY ??? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Ah, yes. Thanks. Didn't have time to test it before whacking it into Production :-) |
|
Back to top |
|
|
Nitin Goel
New User
Joined: 21 Aug 2013 Posts: 2 Location: India
|
|
|
|
Thanks Bill, I was able to get the results |
|
Back to top |
|
|
|