Easytreive compare Logic with Duplicate
Posted: Thu Dec 16, 2010 4:56 pmI am facing the following difficulty in comparing the file using easytrieve. Could anyone guide me on the same?
- File 1 has sorted records by key values
- File 2 has sorted records by key values with duplicate
I need to have the duplicate records in file2 when it founds a match in file 1
EX
File 1(1st 3 byte is Key field)
111 AAA
222 BBB
333 CCC
444 DDD
File 2(1st 3 byte is key field)
111 AAA
222 BBB
222 BBB
222 BBB
555 EEE
Expected Output:
111 AAA
222 BBB
222 BBB
222 BBB
Could anyone help me if there are any possibility/keywords?
Regards,
Gopi
- File 1 has sorted records by key values
- File 2 has sorted records by key values with duplicate
I need to have the duplicate records in file2 when it founds a match in file 1
EX
File 1(1st 3 byte is Key field)
111 AAA
222 BBB
333 CCC
444 DDD
File 2(1st 3 byte is key field)
111 AAA
222 BBB
222 BBB
222 BBB
555 EEE
Expected Output:
111 AAA
222 BBB
222 BBB
222 BBB
Could anyone help me if there are any possibility/keywords?
Regards,
Gopi