Code: Select all
ID CODE
11111 AAAA
11111 BBBB
11111 CCCC
11111 EEEE
22222 AAAA
22222 CCCC
22222 DDDD
22222 EEEE
22222 FFFF
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
Code: Select all
ID CODE
11111 CCCC
11111 EEEE
22222 AAAA