topic Re: Removing duplicates on loading - how to do? in QlikView https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138072#M760555 <HTML><HEAD></HEAD><BODY><P>One way is as below:</P><P><SPAN style="font-size: 8pt;">Data:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">Load</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ID</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,'',</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,'',</SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sex</SPAN><SPAN style="font-size: 8pt;">;<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">Load</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Inline</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> ID, email1, email2, email3, Sex <BR /><SPAN> 12345, </SPAN><A class="jive-link-email-small" href="mailto:jazzy@gmail.com">jazzy@gmail.com</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:jj@hotmail.co.uk">jj@hotmail.co.uk</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:jazzy@gmail.com">jazzy@gmail.com</A><SPAN>,F </SPAN><BR /><SPAN> 23456, </SPAN><A class="jive-link-email-small" href="mailto:beano@yahoo.co.uk">beano@yahoo.co.uk</A><SPAN>, ,</SPAN><A class="jive-link-email-small" href="mailto:beano@marks.com">beano@marks.com</A><SPAN>,M </SPAN><BR /><SPAN> 34567, </SPAN><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com">loopyloo@gmail.com</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com">loopyloo@gmail.com</A><SPAN>,,F </SPAN><BR /><SPAN> 75432, fred.b.@ukmail.com, </SPAN><A class="jive-link-email-small" href="mailto:freddie@hotmail.co.uk">freddie@hotmail.co.uk</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:fred.bar@fedex.com">fred.bar@fedex.com</A><SPAN>,M </SPAN><BR /> ]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210824_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Tue, 14 Aug 2018 16:26:54 GMT trdandamudi 2018-08-14T16:26:54Z Removing duplicates on loading - how to do? https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138071#M760554 <HTML><HEAD></HEAD><BODY><P>I have loaded the following data into a Qlikview Model</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="539"><TBODY><TR><TD height="20" style="border: 0.66px solid #000000;" width="42"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ID</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="141"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email1</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="154"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email2</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email3</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Sex</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">12345</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:jazzy@gmail.com" target="_blank">jazzy@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:jj@hotmail.co.uk" target="_blank">jj@hotmail.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:jazzy@gmail.com" target="_blank">jazzy@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">23456</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:beano@yahoo.co.uk" target="_blank">beano@yahoo.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:beano@marks.com" target="_blank">beano@marks.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">M</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">34567</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com" target="_blank">loopyloo@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com" target="_blank">loopyloo@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">75432</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;">fred.b.@ukmail.com</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:freddie@hotmail.co.uk" target="_blank">freddie@hotmail.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:fred.bar@fedex.com" target="_blank">fred.bar@fedex.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">M</SPAN></TD></TR></TBODY></TABLE><P></P><P>I wanted to keep only unique emails - how can I do this?</P><P>My output should look like this...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="539"><TBODY><TR><TD height="20" style="border: 0.66px solid #000000;" width="42"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ID</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="141"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email1</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="154"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email2</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">email3</SPAN></TD><TD style="border-width: 0.66px 0.66px 0.66px 0px; border-style: solid solid solid none; border-color: #000000;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Sex</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">12345</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:jazzy@gmail.com" target="_blank">jazzy@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:jj@hotmail.co.uk" target="_blank">jj@hotmail.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">23456</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:beano@yahoo.co.uk" target="_blank">beano@yahoo.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:beano@marks.com" target="_blank">beano@marks.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">M</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">34567</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com" target="_blank">loopyloo@gmail.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.66px 0.66px; border-style: none solid solid; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">75432</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;">fred.b.@ukmail.com</SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:freddie@hotmail.co.uk" target="_blank">freddie@hotmail.co.uk</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: windowtext; font-size: 12pt; font-family: Calibri;"><A class="jive-link-email-small" href="mailto:fred.bar@fedex.com" target="_blank">fred.bar@fedex.com</A></SPAN></TD><TD style="border-width: 0px 0.66px 0.66px 0px; border-style: none solid solid none; border-color: #000000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">M</SPAN></TD></TR></TBODY></TABLE><P></P><P>Any help gratefully received.</P><P>Thanks</P><P>JazzyK</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138071#M760554 Anonymous 2020-11-25T16:16:04Z Re: Removing duplicates on loading - how to do? https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138072#M760555 <HTML><HEAD></HEAD><BODY><P>One way is as below:</P><P><SPAN style="font-size: 8pt;">Data:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">Load</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ID</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,'',</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email2</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">email1</SPAN><SPAN style="font-size: 8pt;">,'',</SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">email3</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sex</SPAN><SPAN style="font-size: 8pt;">;<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">Load</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Inline</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> ID, email1, email2, email3, Sex <BR /><SPAN> 12345, </SPAN><A class="jive-link-email-small" href="mailto:jazzy@gmail.com">jazzy@gmail.com</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:jj@hotmail.co.uk">jj@hotmail.co.uk</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:jazzy@gmail.com">jazzy@gmail.com</A><SPAN>,F </SPAN><BR /><SPAN> 23456, </SPAN><A class="jive-link-email-small" href="mailto:beano@yahoo.co.uk">beano@yahoo.co.uk</A><SPAN>, ,</SPAN><A class="jive-link-email-small" href="mailto:beano@marks.com">beano@marks.com</A><SPAN>,M </SPAN><BR /><SPAN> 34567, </SPAN><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com">loopyloo@gmail.com</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:loopyloo@gmail.com">loopyloo@gmail.com</A><SPAN>,,F </SPAN><BR /><SPAN> 75432, fred.b.@ukmail.com, </SPAN><A class="jive-link-email-small" href="mailto:freddie@hotmail.co.uk">freddie@hotmail.co.uk</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:fred.bar@fedex.com">fred.bar@fedex.com</A><SPAN>,M </SPAN><BR /> ]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210824_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Tue, 14 Aug 2018 16:26:54 GMT https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138072#M760555 trdandamudi 2018-08-14T16:26:54Z Re: Removing duplicates on loading - how to do? https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138073#M760556 <HTML><HEAD></HEAD><BODY><P>Thank you - worked perfectly - so simple when I think about it...always learning <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 14 Aug 2018 17:45:57 GMT https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138073#M760556 Anonymous 2018-08-14T17:45:57Z Re: Removing duplicates on loading - how to do? https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138074#M760557 <HTML><HEAD></HEAD><BODY><P>You are welcome. Keep learning you will be better day by day.</P></BODY></HTML> Tue, 14 Aug 2018 17:48:41 GMT https://community.qlik.com/t5/QlikView/Removing-duplicates-on-loading-how-to-do/m-p/138074#M760557 trdandamudi 2018-08-14T17:48:41Z