Joel - Ignore duplicates is not an option in Gateway, so I'd say you have a couple of options:
1. Put in an enhancement request to the RDCC 2. Load the file into a temporary table then do an append to the original table 3. Try using the LOAD command with the AS CSV option instead of using Gateway Sami ------------------------------------------ Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 mailto:[EMAIL PROTECTED] www.softwaremgmt.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joel Solomon Sent: Thursday, July 22, 2004 12:06 PM To: RBG7-L Mailing List Subject: [RBG7-L] - File Gateway Good Afternoon, I am trying to import a .csv file into a table. The table has an index that looks for a unique value. The ..csv file has duplicates in it and I want them to filter out when I import them. I cannot find an option in Gateway that allows the records to be ignored at the time of executing, therefore each time it finds a duplicate the import aborts. Does anyone have any ideas? Joel Solomon Controller Barbizon International [EMAIL PROTECTED]
