Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
GiuQlik
Partner - Contributor II
Partner - Contributor II

Load duplicate rows into Qlik Data Manager

Hi,

I have prepared my data model and loaded the tables via Data Manager in QLik Sense.

After creating the Dashboard, doing some checks against the table in the DB, I noticed that some duplicate rows had been eliminated. I realize it may seem strange, but for the work I do, duplicates are important and I cannot allow them to be eliminated.

Is there a way to forcefully load the tables as per my needs? I imagined there might be a setting that escapes me that is useful for this purpose.

Thank you very much for your availability.

Labels (3)
1 Reply
marcus_sommer
MVP
MVP

You may have added a DISTINCT statement to a load and/or applied any explicit/implicit filtering - explicit means applying a where-clause and implicit any join-statement. Be aware that merging tables per join/concatenate the DISTINCT worked in both directions - not only the one in which it was called.