'm trying to import a text file but the primary key column contains duplicatres (tunrs out to be the nature of the legacy data). How can I kick out all duplicates except, say, for a single primary key value?
TIA,
Barkingdog
SORT component has the ability to eradicate dupes. Have you looked into using that?
-Jamie
|||
No, but I will.
BTW does SORT allow me to send those dups to an "erorr" file so I can see I can further investigate those "bad" records?
Barkingdog
|||No, you can't do that. But you could easily use an AGGREGATE followed by a conditional split to get all those where the key appears more than once.
-Jamie
No comments:
Post a Comment