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: 
Anonymous
Not applicable

not load duplicate data

Hi,

I only want to load dubble data once.

Is there a formula I can put in the load script?

dubbele data.PNG

Thx

4 Replies
Digvijay_Singh

You can use distinct in the load statement!

Anonymous
Not applicable
Author

hello Digvijay,

column 'etikettnr' contains still the same double data.

Anonymous
Not applicable
Author

Tack a Where not exists ( [etikettnr] ) onto the end of your load statement.

Anonymous
Not applicable
Author

hello Bill,

now he shows me non of the double's and I still want to see one record  of them.

grtz