Merge 2 files based on account number

pkmurali · Active User Joined: 15 Dec 2005 Posts: 56

Dear all,

I want to merge 2 file for ex fil1,fil2 which is having following input

fil1
98765432
34567891
11111111
22222222

fil2
11111111
22222222

and the output should be
outfil
11111111
22222222

Regards,
Murali.

Anuj D. · Posted: Thu Mar 27, 2008 1:41 pm Post subject:

Hi,

I didn't understand why did you use the term "Merge", ouput shown is actually the common records between two files. Before someone go ahead with further suggestions, please clarify what exaclty you are looking for.

expat · Posted: Thu Mar 27, 2008 5:06 pm Post subject:

And supply record formats, record lengths, and key positions.

Frank Yaeger · Posted: Thu Mar 27, 2008 9:20 pm Post subject:

Can input file1 have duplicates within it?

Can input file2 have duplicates within it?

If either file can have duplicates within it, show that in your example of input records and expected output records.

pkmurali · Active User Joined: 15 Dec 2005 Posts: 56

Hi Frank,

Both input & output doesn'y have duplicates.

Regards,
Murali.

Frank Yaeger · Posted: Mon Mar 31, 2008 9:23 pm Post subject:

Murali,

You haven't given a lot of information. Assuming you want the records from file1 that have a match in file2, you can use a DFSORT/ICETOOL job like this: