topic duplicate records in QlikView https://community.qlik.com/t5/QlikView/duplicate-records/m-p/419113#M1160801 <HTML><HEAD></HEAD><BODY><P>I'm loading into QV two spreadsheets where I want to identify duplicates. Column names are similar to</P><P>Table 1</P><P>Date</P><P>Site</P><P>Breach</P><P>Score</P><P></P><P>Table2</P><P>Date</P><P>Site</P><P>Reason</P><P>Value</P><P></P><P>I want to find all the duplicate records where all values match, so there will be some text in the breach and reason colunm that should match, same with date etc. Each table has about 200 records. </P><P></P><P>Anyone got any suggestions. Thanks</P></BODY></HTML> Sat, 08 Dec 2012 09:44:21 GMT 2012-12-08T09:44:21Z duplicate records https://community.qlik.com/t5/QlikView/duplicate-records/m-p/419113#M1160801 <HTML><HEAD></HEAD><BODY><P>I'm loading into QV two spreadsheets where I want to identify duplicates. Column names are similar to</P><P>Table 1</P><P>Date</P><P>Site</P><P>Breach</P><P>Score</P><P></P><P>Table2</P><P>Date</P><P>Site</P><P>Reason</P><P>Value</P><P></P><P>I want to find all the duplicate records where all values match, so there will be some text in the breach and reason colunm that should match, same with date etc. Each table has about 200 records. </P><P></P><P>Anyone got any suggestions. Thanks</P></BODY></HTML> Sat, 08 Dec 2012 09:44:21 GMT https://community.qlik.com/t5/QlikView/duplicate-records/m-p/419113#M1160801 2012-12-08T09:44:21Z