topic Re: Incremental Load in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028865#M931645 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for all your help.</P></BODY></HTML> Tue, 08 Mar 2016 13:59:09 GMT 2016-03-08T13:59:09Z Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028859#M931639 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to do a Insert and Update Incremental Load but it's unable to function. I have two date fields in my DB table (insert date and update date) and I'm using the update date as the modified date. Please find attached the copy and please provide assistance in implementing it.</P><P></P><P>Thanks in Advance,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028859#M931639 2020-11-25T16:16:04Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028860#M931640 <HTML><HEAD></HEAD><BODY><P>When you say it is unable to function, are you getting some kind of error? What isn't working?</P></BODY></HTML> Tue, 08 Mar 2016 13:35:45 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028860#M931640 sunny_talwar 2016-03-08T13:35:45Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028861#M931641 <HTML><HEAD></HEAD><BODY><P>Thanks for the speedy reply Sunny.<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117346_Capture.PNG" style="height: 189px; width: 620px;" /></P></BODY></HTML> Tue, 08 Mar 2016 13:38:16 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028861#M931641 2016-03-08T13:38:16Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028862#M931642 <HTML><HEAD></HEAD><BODY><P>vLastRunTime variable needs to be formatted correctly.</P><P></P><P><STRONG>vLastRunTime = Date(Today(), 'DD-MMM-YYYY')</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 13:43:52 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028862#M931642 sunny_talwar 2016-03-08T13:43:52Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028863#M931643 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117363_Capture.PNG" style="height: auto;" /><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/117365_Capture1.PNG" style="height: auto;" /></P><P></P><P>I'm getting the above error.</P></BODY></HTML> Tue, 08 Mar 2016 13:50:57 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028863#M931643 2016-03-08T13:50:57Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028864#M931644 <HTML><HEAD></HEAD><BODY><P>Can you add single quotes around&nbsp; the variable?</P><P></P><P><STRONG>Where updatedate &gt; '$(vLastRunTime)'</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 13:54:56 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028864#M931644 sunny_talwar 2016-03-08T13:54:56Z Re: Incremental Load https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028865#M931645 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for all your help.</P></BODY></HTML> Tue, 08 Mar 2016 13:59:09 GMT https://community.qlik.com/t5/QlikView/Incremental-Load/m-p/1028865#M931645 2016-03-08T13:59:09Z