topic Depurate excel table in QlikView https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317288#M1196734 <HTML><HEAD></HEAD><BODY><P>Could you post a sample data and application.</P><P></P><P>- Sridhar </P></BODY></HTML> Sat, 21 May 2011 03:39:59 GMT 2011-05-21T03:39:59Z Depurate excel table https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317287#M1196733 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I loaded an excel table into QV with Customer information (Contact name, Compañy, Telephone, email, etc). For example,I have rows with the same email. how can i show&nbsp; in a straight table only the records that has not duplicate information? </P><P></P><P>thank a lot,</P><P></P><P>angel</P></BODY></HTML> Fri, 20 May 2011 22:00:15 GMT https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317287#M1196733 2011-05-20T22:00:15Z Depurate excel table https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317288#M1196734 <HTML><HEAD></HEAD><BODY><P>Could you post a sample data and application.</P><P></P><P>- Sridhar </P></BODY></HTML> Sat, 21 May 2011 03:39:59 GMT https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317288#M1196734 2011-05-21T03:39:59Z Depurate excel table https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317289#M1196735 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; You can use the "Distinct" keyword before your field name.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sat, 21 May 2011 07:53:28 GMT https://community.qlik.com/t5/QlikView/Depurate-excel-table/m-p/317289#M1196735 kaushiknsolanki 2011-05-21T07:53:28Z