Page 1 of 1

Help Required on Joinkeys

PostPosted: Mon Dec 01, 2014 1:17 pm
by neo4u
Hi Frieds,

I have a requirement where I need to find if a keys in file-1 is present in File-2. I would need to stop the processing for a particular key once a match is found, the search should then continue for the next key. This is because file-2 is humongous!! and just a simple sort is taking hell lot of time (more than 4 hours!!!). Is it possible using SYNCSORT? My shop uses syncsort.


Thanks

Re: Help Required on Joinkeys

PostPosted: Mon Dec 01, 2014 1:59 pm
by BillyBoyo
Can you show what you have tried, including the fully sysout from the step which took four hours? Also a short reperentative example of what you mean, input and expected output.

Re: Help Required on Joinkeys

PostPosted: Tue Dec 02, 2014 10:31 am
by neo4u
Hi Billy,

My Requirement is as below
File-1
value | key
a | 1
b | 2
c | 2
d | 4
..

File-2
Key
1
2
3
5
6
...

What I need is, for value "a" in file-1 the key value should be seached in file-2 and if there's a match I should write it to output with some indicator. Sample output is as below
A Yes
B Yes
C Yes
D No


My Sort card looks like this,
SORT FIELDS=(204,10,CH,A)             
SUM FIELDS=NONE                       
OUTFIL FNAMES=FBOUT,VTOF,BUILD=(204,10)

I was just trying to get the list and then put it into excel and vlookup to get the desired output, but the job got cancelled by operator.

Re: Help Required on Joinkeys

PostPosted: Thu Dec 04, 2014 12:07 pm
by neo4u
I was able to do this using ICETOOL.. Thanks!! Closing the thread.

Re: Help Required on Joinkeys

PostPosted: Thu Dec 04, 2014 1:21 pm
by BillyBoyo
Good for you. If you'd like to post your solution, we may be able to suggest improvements.