|
View previous topic :: View next topic
|
| Author |
Message |
Chirag Dhull
New User
Joined: 29 Aug 2008
Posts: 8
Location: Bangalore
|
|
|
|
Hi,
I need to find the Duplicate Records when comparing two copies of the same file . one copy has the duplicates , other doesnt .
For Eg : -
File A :-
A
B
C
B
D
E
D
File B : -
A
B
C
D
E
So , i want the Output file to have O/p :
B
D
Is it possible without using Comparex?? |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
It's not clear what you want to do. Your example doesn't make it clear which records in which input files you want in the output file. Please show a better example of your input records and what you want for output with all relevant variations, and explain the "rules" for getting from input to output. For example:
The key is in position 1. The other field is an "identifier".
| Code: |
File A :-
A F1A1
B F1B1
C F1C1
B F1B2
D F1D1
E F1E1
D F1D2
File B : -
A F2A1
B F2B1
C F2C1
D F2D1
E F2E1
Output
????
|
|
|
| Back to top |
|
|
|
|
