Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
seniorps
Contributor III
Contributor III

Allow duplicate rows in Excel load

Hi all

I have an Excel file to load into Qlik Sense. The file contains some duplicate lines, which on this occasion I would like to retain. When loaded into Qlik Sense it seems to automatically remove duplicates.

Any ideas on the best way to allow the import of duplicate rows?

Thanks

Paul

3 Replies
swuehl
MVP
MVP

I think the duplicate rows are not removed.

But depending where and how you are trying to visualize the records, only unique combinations of field values might be shown.

Check the total number of records in your table or add a record counter using Recno() as RecID in your LOAD.

seniorps
Contributor III
Contributor III
Author

Thanks for your reply and the recno() tip. The problem was actually related to using wildcards to enable multiple files to load. When each file is loaded separately, the problem does not occur.

Thanks

Paul

swuehl
MVP
MVP

Hi Paul,

even using a wildcard to load multiple Excel files should not remove the duplicate records. Unless you are using a WHERE clause with e.g. Exists().