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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not Import Double Rows

Hello all,

It Is possible to import a file that the double rows not import in QlikView?

With friendly regards,

Hans

1 Solution

Accepted Solutions
Not applicable
Author

hi,

did you try with load distinct...

View solution in original post

3 Replies
Not applicable
Author

hi,

did you try with load distinct...

Not applicable
Author

If you are loading double rows, then it probably means that there is something wrong with the data in Qlikview. If you are going from SQL, then as Krunoslav has suggested, you need a SQL SELECT DISTINCT * FROM table at the beginning of the statement,

Kind Regards,

Miles

Not applicable
Author

Hello all,

It is true that I have duplicate rules come back, that is indeed a problem in the source data. With the code load distinct I can fix this in QV.

Thanks!


With friendly regards,

Hans Steenhuis