Key position = 1,6,a, 8,4,a,15,1,a
Key position = 1,6,a, 28,4,a, 46,1,a
File-1 contains multiple rows of matching records with file-2. Similarly file-2 also contains multiple rows of matching record with file-1.
Requirement: Using file-1 has driver select all rows with matching records from file-2 and create the formatted output as follows.
Output file should be copy all rows from file-1 and MATCHED rows from file-2. Any unmatched rows in file-2 should not be copied to output file.
We are using SYNCSORT vendor tool and please provide JOINKEYS suntax. Thx