topic Re: when i impement incremental load one error is occurred and how to get the solution please help me... in QlikView https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849987#M995120 <HTML><HEAD></HEAD><BODY><P>hi bill,</P><P>&nbsp;&nbsp; i tried this still i'm getting the same error.</P><P></P><P></P><P></P><P></P><P>thanks &amp; regards</P><P>raja</P></BODY></HTML> Tue, 30 Jun 2015 11:18:38 GMT 2015-06-30T11:18:38Z when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849981#M995114 <HTML><HEAD></HEAD><BODY><P>when i impement incremental load one error is occurred and how to get the solution please help me...</P><P></P><P>&nbsp; Please find the attached details.</P><P></P><P></P><P></P><P>Thanks &amp; regards</P><P>raja</P></BODY></HTML> Tue, 30 Jun 2015 10:52:21 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849981#M995114 2015-06-30T10:52:21Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849982#M995115 <HTML><HEAD></HEAD><BODY><P>What is in your variable <EM>vHIREDATE</EM> ?</P></BODY></HTML> Tue, 30 Jun 2015 10:54:45 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849982#M995115 Anonymous 2015-06-30T10:54:45Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849983#M995116 <HTML><HEAD></HEAD><BODY><P>Hi Raja,</P><P></P><P>What is there in Your variable( vHIREDATE) -----?</P><P></P><P></P><P>Ramya.</P></BODY></HTML> Tue, 30 Jun 2015 10:59:33 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849983#M995116 2015-06-30T10:59:33Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849984#M995117 <HTML><HEAD></HEAD><BODY><P>!</P></BODY></HTML> Tue, 30 Jun 2015 11:01:35 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849984#M995117 2015-06-30T11:01:35Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849985#M995118 <HTML><HEAD></HEAD><BODY><P>hi ramya ,</P><P>&nbsp;&nbsp; please find the attached document.</P><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks &amp; regards</P><P>raja</P></BODY></HTML> Tue, 30 Jun 2015 11:06:45 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849985#M995118 2015-06-30T11:06:45Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849986#M995119 <HTML><HEAD></HEAD><BODY><P>Try something like :</P><P></P><P style="padding-left: 30px;"><EM>HireDate_Emp:</EM></P><P style="padding-left: 30px;"><EM>NoConcatenate</EM></P><P style="padding-left: 30px;"><EM>LOAD <SPAN style="font-size: 13.3333330154419px;">HIREDATE</SPAN></EM></P><P style="padding-left: 30px;"><EM>Resident Employee</EM></P><P style="padding-left: 30px;"><EM>Order By HIREDATE <SPAN style="color: #ff0000;"><STRONG>asc</STRONG></SPAN>;</EM></P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;"><EM>LET vHIREDATE = Peek('HIREDATE',0,'HireDate_Emp');</EM></P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;"><SPAN style="color: #ff0000;"><STRONG><EM>trace $(vHIREDATE) ;</EM></STRONG></SPAN></P></BODY></HTML> Tue, 30 Jun 2015 11:11:13 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849986#M995119 Anonymous 2015-06-30T11:11:13Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849987#M995120 <HTML><HEAD></HEAD><BODY><P>hi bill,</P><P>&nbsp;&nbsp; i tried this still i'm getting the same error.</P><P></P><P></P><P></P><P></P><P>thanks &amp; regards</P><P>raja</P></BODY></HTML> Tue, 30 Jun 2015 11:18:38 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849987#M995120 2015-06-30T11:18:38Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849988#M995121 <HTML><HEAD></HEAD><BODY><P>Hi Raja,</P><P></P><P></P><P>U can try this variable: </P><P></P><P></P><P>LET vHIREDATE = Peek('HIREDATE',0,'HireDate_Emp');</P><P>trace $(vHIREDATE)</P><P></P><P></P><P></P><P></P><P>Ramya.</P></BODY></HTML> Tue, 30 Jun 2015 11:20:45 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849988#M995121 2015-06-30T11:20:45Z Re: when i impement incremental load one error is occurred and how to get the solution please help me... https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849989#M995122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I think it is a problem with Date field u r using the field as hiredate,</P><P>check with the database time format it is matching with it r not.</P><P></P><P>before that, check with this</P><P><STRONG>where hiredate &gt;= Today();</STRONG></P><P></P><P>I hope it will help u to complete u r task.</P><P></P><P>Thank you,</P><P>Balaji.k</P></BODY></HTML> Tue, 30 Jun 2015 14:01:54 GMT https://community.qlik.com/t5/QlikView/when-i-impement-incremental-load-one-error-is-occurred-and-how/m-p/849989#M995122 2015-06-30T14:01:54Z