Skip to content
+1-888-319-3663

COMMUNITY FORUM

Excel Datasource – Importing Duplicate Rows

Mick asked 10 months 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.
Thanks,
Mick
Answers
Best Answer
Mick answered 9 months 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.
 
Mick

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