|
View previous topic :: View next topic
|
| Author |
Message |
elangovalan
New User
Joined: 10 Mar 2008
Posts: 1
Location: Coimbatore
|
|
|
|
| The requirement is, I have two files and I have to find the unmatched records based on a key value. The key value is in different format in the input files. File1 has the key value in Binary format and file 2 has the key value in the ZD format. I already tried sorting with Joinkeys but it didn't work since the key is in different format. Is there a way to find the unmatched records? |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| Record lengths and Formats, key positions and lengths, etc.? |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
elangovan,
| Quote: |
| I already tried sorting with Joinkeys |
Are you using SYNCSORT??
If you are using DFSORT, first convert and make the data formats same and then use SELECT operator to get the unmatched records. |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
elangovalan,
In a prior step, you can convert the JOINKEYS FIELD in the smaller file so they match, and then run the JOIN application.
Regards, |
|
| Back to top |
|
|
|
|
