Skip to content


Excel Datasource – Importing Duplicate Rows

Mick asked 2 years ago
I have created a Map with a custom eConnect Stored Procedure to import an excel spreadhseet.
The issue is when duplicate rows exist in the file, the second duplicate row doesn’t Import.
It appears the Key Fields selection excludes the duplicated row.
is there a way to have all the data imported into the SQL Data Table.
I have attpemted using the Excel Data Source, and creating an Excel ODBC Connection and selecting for the work sheet.
I tried to add a Row Number to the query, but this doesn’t appear possible for excel queries.
Best Answer
Mick answered 2 years ago
I ended up using the excel query “select * from [file]”, and using the Group BY and SUM in the Mapping was able to get around the issue.

If you would like to submit an answer or comment, please sign in to the eOne portal.