Eleminating DUP rows in syncsort

joseph murphy · New User Joined: 24 Nov 2008 Posts: 17 Location: USA

File A
******
ID
--
123

File B
*****
ID City
--- ---
123 Co
123 TX
123 AG

In Sync Sort i am doing

JOIN KEYS F1=(1,3)
JOIN KEYS F2=(1,3)
JOIN UNPAIRED,F1
REFORMAT(F1:1,3,F2:1,3,F2:4,2)

i need the output like ,

123 TX

i dont need the other two rows in the output,how can i achieve this in syncsort,

dick scherrer · Posted: Wed Feb 18, 2009 1:26 am

Hello,

What "rule" determines that the TX record is the one kept?

What if there were these records:
123 Co
123 TX
123 AG
123 MM
123 TG
123 GG

Or more, or less. . .

Quite difficult to implement with no rules. . .

Alissa Margulies · Posted: Wed Feb 18, 2009 9:15 pm

Joseph,

If you are going to post your request in a public forum, please do not send me a private email with the exact same question. I have already provided you with an initial solution based on your original request. Since you have apparently changed the requirements, please post the complete rules here, as Dick has requested.

Thank you.