topic Re: not load duplicate data in App Development https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82939#M5509 <HTML><HEAD></HEAD><BODY><P>Tack a <EM>Where not exists ( [<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">etikettnr</SPAN>] )</EM> onto the end of your load statement.</P></BODY></HTML> Fri, 09 Feb 2018 19:24:42 GMT Anonymous 2018-02-09T19:24:42Z not load duplicate data https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82936#M5506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I only want to load dubble data once.</P><P>Is there a formula I can put in the load script?</P><P></P><P><IMG alt="dubbele data.PNG" class="jive-image image-1" src="/legacyfs/online/193012_dubbele data.PNG" style="width: 620px; height: 128px;" /></P><P></P><P></P><P>Thx</P></BODY></HTML> Fri, 09 Feb 2018 18:50:29 GMT https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82936#M5506 Anonymous 2018-02-09T18:50:29Z Re: not load duplicate data https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82937#M5507 <HTML><HEAD></HEAD><BODY><P>You can use distinct in the load statement!</P></BODY></HTML> Fri, 09 Feb 2018 19:02:13 GMT https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82937#M5507 Digvijay_Singh 2018-02-09T19:02:13Z Re: not load duplicate data https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82938#M5508 <HTML><HEAD></HEAD><BODY><P>hello Digvijay,</P><P></P><P>column 'etikettnr' contains still the same double data.</P></BODY></HTML> Fri, 09 Feb 2018 19:12:42 GMT https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82938#M5508 Anonymous 2018-02-09T19:12:42Z Re: not load duplicate data https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82939#M5509 <HTML><HEAD></HEAD><BODY><P>Tack a <EM>Where not exists ( [<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">etikettnr</SPAN>] )</EM> onto the end of your load statement.</P></BODY></HTML> Fri, 09 Feb 2018 19:24:42 GMT https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82939#M5509 Anonymous 2018-02-09T19:24:42Z Re: not load duplicate data https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82940#M5510 <HTML><HEAD></HEAD><BODY><P>hello Bill,</P><P></P><P>now he shows me non of the double's and I still want to see one record&nbsp; of them.</P><P></P><P>grtz</P></BODY></HTML> Fri, 09 Feb 2018 20:14:29 GMT https://community.qlik.com/t5/App-Development/not-load-duplicate-data/m-p/82940#M5510 Anonymous 2018-02-09T20:14:29Z