Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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().