Page 1 of 1

Joinkeys

PostPosted: Sun Mar 09, 2014 12:37 pm
by jayasakthivel
Hi ,
I need to compare two files in files in which i need to compare the first file for different positions.
input1:
05 a
05 abcd
02 ab

Input2:
05 a plana
05 b planb
05 c planc
05 d pland


First i need to compare 4 th position, if it matches have to write file 2 , then it needs to compare 5 th position ,then 6 th positin and so on till 10.is there any way possible that we can do it in Joinkeys in a single step.it takes 6 steps for me as i put compare for each position.Please help.

Re: Joinkeys

PostPosted: Sun Mar 09, 2014 12:39 pm
by jayasakthivel
First i need to compare 4 th position,with the 4 th position in file2. if it matches have to write file 2 , then it needs to compare 5 th position of file1 with 4 th position of file2 ,then 6 th positin and so on till 10 th position of file1 .Is there any way possible that we can do it in Joinkeys in a single step.it takes 6 steps for me as i put compare for each position.Please help.
jayasakthivel

Posts: 1
Joined: Fri Jan 03, 2014 7:19 am

Re: Joinkeys

PostPosted: Sun Mar 09, 2014 7:50 pm
by BillyBoyo
You'll need to describe what you want to do when you get a match, when you don't get a match.

How many records on each file? What LRECL and RECFM?

Re: Joinkeys

PostPosted: Mon Mar 10, 2014 3:59 am
by dick scherrer
Hello,

If the sample data does not cover all cases, add some more sample data.

Then show the output(s) you want from the complete sample data.