Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

leroboy1980
New Contributor

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
Honored Contributor III

Re: not load duplicate data

You can use distinct in the load statement!

leroboy1980
New Contributor

Re: not load duplicate data

hello Digvijay,

column 'etikettnr' contains still the same double data.

Re: not load duplicate data

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

leroboy1980
New Contributor

Re: not load duplicate data

hello Bill,

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

grtz

Community Browser