How to compare 2 files in fileaid?

chtrisa · New User Joined: 19 Dec 2006 Posts: 12 Location: chennai

I have 2 flat files. i want to compare 2 files and list the different records.

for an ex:

input files
File1
aaa
bbb
ddd
hhh

File2
bbb
sss
ddd
zzz

the output must be
aaa
hhh

how to do this can any one suggest me

dick scherrer · Posted: Sun Apr 29, 2007 7:56 am

Hello,

To get the result you want, please search in the DFSORT forum.

Your question has been solved there. Hopefully, you are not restricted to using FileAid. . .

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

Hi the scenario presented by chtrisa cant be done using file-aid?.

krisprems · Posted: Tue Jun 19, 2007 4:42 pm

chtrisa
you can do this using DFSORT.

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

Hi krisprems is there any possibility that what chtrisa wanted can be done in file-aid with out using dfsort.

krisprems · Posted: Wed Jul 11, 2007 1:16 pm

student_mf
I dont have much hands on File-Aid and so can't answer your question

dick scherrer · Posted: Wed Jul 11, 2007 8:04 pm

Hello,

Are you just curious or is there a business reason for:

lalitha_gld · New User Joined: 12 Jul 2006 Posts: 24

I assume that you would know to do a basic compare using Fileaid option '10'.

To get the required output:
1. Mention file1 as OLD dataset & file2 as NEW dataset.
2. Under 'Compare - Criteria Options' set 'Modify print defaults' to 'y'.
3. Set 'Print DELETED records ===> Y '
4.Execute compare.

You will get the records from the file1 which are missed in file2.

Thanks,
Lalitha.

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

thanks lalitha i got the required output