if matched for not sorted files



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

if matched for not sorted files

Postby gyt3 » Thu Dec 20, 2012 12:19 am

Hi ...

I have two input files

1st Input files is sorted and contains duplicates

2nd Input file is not sorted and it does not contain duplicate.

I want to compare 1st file with second file and write (matched records) and (unmatched records of file1) in two different files

Can I do it through If matched logic in Eazytrieve... Will i get any errors as the 2nd file is not sorted.

input file 1
a12345
b11555
a12345
c15151
d54545


input file2

z12345
a12345
b11555
c45545
e465456



I need quick reply and it is very urgent,
gyt3
 
Posts: 16
Joined: Sun Dec 16, 2012 9:58 am
Has thanked: 3 times
Been thanked: 0 time

Re: if matched for not sorted files

Postby dick scherrer » Thu Dec 20, 2012 12:32 am

Hello,

If you believe you have an urgent issue, the forum is Not the place to go. There is no guarantee that an answer will be posted quickly or even at all . . .

You need to sort the unsorted data and then match the files.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: if matched for not sorted files

Postby BillyBoyo » Thu Dec 20, 2012 3:22 am

gyt3,

For Synchronised File Processing both the files need to be in sequence if you hope to match anything sensibly.

If you have duplicates on one file, and no duplicates on the other, make the no-duplicates file the FIRST file. You'll find it much easier to deal with the match that way.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: if matched for not sorted files

Postby c62ap90 » Thu Dec 20, 2012 8:39 pm

Hmmm, seems my posts were deleted. Probably a technical glitch.
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times

Re: if matched for not sorted files

Postby dick scherrer » Thu Dec 20, 2012 8:46 pm

Hello,

No, no glitch.

We routinely review topics and remove posts that do not (or no longer) contribute to the "solution". I've deleted more than 500 of my own replies over time . . .

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: if matched for not sorted files

Postby BillyBoyo » Thu Dec 20, 2012 8:52 pm

Yes, just zapped one of my own from the thread, as no longer "attached" to anything. We do try to keep threads "manageable" for people doing their own research for a particular problem.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: if matched for not sorted files

Postby c62ap90 » Thu Dec 20, 2012 8:56 pm

Yea, okay.
Well, whoever works on a "solution" note that the original poster 'input file 1' example data is not in sorted order.
gyt3 wrote:1st Input files is sorted and contains duplicates
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post