topic Incremental reload - Comparing sql database to qvd in App Development https://community.qlik.com/t5/App-Development/Incremental-reload-Comparing-sql-database-to-qvd/m-p/31968#M2143 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>For a current project, we would like to have an incremental reload. </P><P>We cannot check the date of our latest record and use this as a variable, because records can change overtime in the DB.</P><P></P><P>What we would like is to use a where exists, but for SQL. </P><P></P><P>We load all our unique ID's from the historic QVD, </P><P>Then we'd like to load everything from our SQL database where there is no match between the ID from the SQL database, and ID from the historic qvd. </P><P></P><P>Anybody has an idea how to realise this? </P><P>Or better suggestions <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Best regards</P><P>Maxim Polderman </P></BODY></HTML> Thu, 29 Mar 2018 15:15:06 GMT maximpoldermani 2018-03-29T15:15:06Z Incremental reload - Comparing sql database to qvd https://community.qlik.com/t5/App-Development/Incremental-reload-Comparing-sql-database-to-qvd/m-p/31968#M2143 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>For a current project, we would like to have an incremental reload. </P><P>We cannot check the date of our latest record and use this as a variable, because records can change overtime in the DB.</P><P></P><P>What we would like is to use a where exists, but for SQL. </P><P></P><P>We load all our unique ID's from the historic QVD, </P><P>Then we'd like to load everything from our SQL database where there is no match between the ID from the SQL database, and ID from the historic qvd. </P><P></P><P>Anybody has an idea how to realise this? </P><P>Or better suggestions <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Best regards</P><P>Maxim Polderman </P></BODY></HTML> Thu, 29 Mar 2018 15:15:06 GMT https://community.qlik.com/t5/App-Development/Incremental-reload-Comparing-sql-database-to-qvd/m-p/31968#M2143 maximpoldermani 2018-03-29T15:15:06Z