Compare two records in the same ps file.

[Sureshpathi10]

I've a requirement to create two output files from one single file.

Code: Select all

ID             CODE
11111          AAAA
11111          BBBB
11111          CCCC
11111          EEEE
22222          AAAA
22222          CCCC
22222          DDDD
22222          EEEE
22222          FFFF

From the above file,
File 1 should contain:
1. Same ID with code 'AAAA' AND 'BBBB'
2. Same ID with code 'CCCC' AND 'DDDD'
2. Same ID with code 'EEEE' AND 'FFFF'

File 2 should contain all other non-matched records

output should be
File 1

Code: Select all

ID             CODE
11111          AAAA
11111          BBBB
22222          CCCC
22222          DDDD
22222          EEEE
22222          FFFF

File 2

Code: Select all

ID             CODE
11111          CCCC
11111          EEEE
22222          AAAA

Any help would be greatly appreciated.

[devegouda.chage]

Hi Sureshpathi10,

Since its confusing with the same ID's..
little explaination needed...
like some condition/logic for considering for file1/ file2

[Sureshpathi10]

Hi Devegouda,

There are only 6 CODEs that forms 3 groups.

AAAA & BBBB - Group 1
CCCC & DDDD - Group 2
EEEE & FFFF - Group 3

If SAME id has any one of the Group mentioned above, it should written to File 1.
All other records should be in File 2.

I Hope this will help you to understand. Thanks for your efforts.

[devegouda.chage]

Hi Suresh,
I may not able to solve your problem ,as it is tricky in choosing the similar record from the ID column,but i found some what similar requirement in the below thread,it may help you


http://www.mainframegurukul.com/ibmmain ... t4890.html

[NicC]

Suresh

You have been members of a forum long enough to know that you do not multiple post the same question at the same time. I suggest a moderator lock all topics bar one.