Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

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.