Yes, Project an empty temporary table from your base table....The Temp Table will have no indexes. Load the Temp Table with the data and Perform the Delete Duplicates command on the data using your criteria and then insert into the Target Table
----- Original Message ----- From: "Joel Solomon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 12:06 PM 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]
