topic Duplicate Records using JOIN in QlikView https://community.qlik.com/t5/QlikView/Duplicate-Records-using-JOIN/m-p/551067#M1145487 <HTML><HEAD></HEAD><BODY><P>Does anyone know if this query can be used in in a LOAD statement?&nbsp; I'm trying to JOIN to tables and need to only pull the top record so there are no duplicates.</P><P></P><P>SELECT *</P><P>FROM your_table</P><P> INNER</P><P>&nbsp; JOIN (</P><P>&nbsp; SELECT your</P><P>&nbsp; , fields</P><P>&nbsp; , Row_Number() OVER (PARTITION BY SessionStartTime ORDER BY ChTimestamp ASC) As row_num</P><P>&nbsp; FROM your_table</P><P>&nbsp; ) As x</P><P>WHERE x.row_num = 1</P></BODY></HTML> Thu, 01 Aug 2013 21:09:05 GMT Anonymous 2013-08-01T21:09:05Z Duplicate Records using JOIN https://community.qlik.com/t5/QlikView/Duplicate-Records-using-JOIN/m-p/551067#M1145487 <HTML><HEAD></HEAD><BODY><P>Does anyone know if this query can be used in in a LOAD statement?&nbsp; I'm trying to JOIN to tables and need to only pull the top record so there are no duplicates.</P><P></P><P>SELECT *</P><P>FROM your_table</P><P> INNER</P><P>&nbsp; JOIN (</P><P>&nbsp; SELECT your</P><P>&nbsp; , fields</P><P>&nbsp; , Row_Number() OVER (PARTITION BY SessionStartTime ORDER BY ChTimestamp ASC) As row_num</P><P>&nbsp; FROM your_table</P><P>&nbsp; ) As x</P><P>WHERE x.row_num = 1</P></BODY></HTML> Thu, 01 Aug 2013 21:09:05 GMT https://community.qlik.com/t5/QlikView/Duplicate-Records-using-JOIN/m-p/551067#M1145487 Anonymous 2013-08-01T21:09:05Z