https://community.qlik.com/t5/Connectivity-Data-Prep/Incremental-Load/m-p/2011041#M11717 <P>Hello, </P> <P>I have a qvd that includes about two years worth of data, and gets replaced from a SQL script each day. Obviously, this is not practical, so we need to start doing incremental loads. The rows can get updated, but it would never happen more than a week from when the record was created. There is a unique TXPORT_ID and LastUpdate field added that can be used for this purpose. I've looked at some examples online, but none seem to quite work. </P> <P>I'd like to run the SQL stored procedure each day, looking back for a week's worth of activity just to be safe. Then I'd like to add the new records that aren't currently in the existing 2+ years qvd, and replace any that may have been updated.</P> <P>What is the best way to do this?</P> Wed, 30 Nov 2022 15:04:25 GMT cfountain72 2022-11-30T15:04:25Z https://community.qlik.com/t5/Connectivity-Data-Prep/Incremental-Load/m-p/2011041#M11717 <P>Hello, </P> <P>I have a qvd that includes about two years worth of data, and gets replaced from a SQL script each day. Obviously, this is not practical, so we need to start doing incremental loads. The rows can get updated, but it would never happen more than a week from when the record was created. There is a unique TXPORT_ID and LastUpdate field added that can be used for this purpose. I've looked at some examples online, but none seem to quite work. </P> <P>I'd like to run the SQL stored procedure each day, looking back for a week's worth of activity just to be safe. Then I'd like to add the new records that aren't currently in the existing 2+ years qvd, and replace any that may have been updated.</P> <P>What is the best way to do this?</P> Wed, 30 Nov 2022 15:04:25 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Incremental-Load/m-p/2011041#M11717 cfountain72 2022-11-30T15:04:25Z