topic Re: Incremental Load with out Audit columns in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890330#M1002380 <HTML><HEAD></HEAD><BODY><P>1. If&nbsp; table has primary key, use like where not exists(primary key column) </P><P>2. If table does not have primary key,&nbsp; create composite key by concatenating two or more columns to create unique record.</P><P>Please share sample data&nbsp; if you are not getting still.</P><P></P><P>Thanks,</P><P>Uday.</P></BODY></HTML> Mon, 15 Jun 2015 09:58:07 GMT 2015-06-15T09:58:07Z Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890327#M1002377 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>My Masters and dimension tables doesn't have audit columns (Created on , updated on), How to i place incremental load???</P><P></P><P>Your help is much appreciated.</P><P></P><P>Thanks &amp; Regards,</P><P></P><P>Raju Kuppusamy</P></BODY></HTML> Mon, 15 Jun 2015 09:43:04 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890327#M1002377 Anonymous 2015-06-15T09:43:04Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890328#M1002378 <HTML><HEAD></HEAD><BODY><P>Do you have a unique key in the tables?</P><P>use that instead</P></BODY></HTML> Mon, 15 Jun 2015 09:45:28 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890328#M1002378 giakoum 2015-06-15T09:45:28Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890329#M1002379 <HTML><HEAD></HEAD><BODY><P style="font-size: 12.8000001907349px; color: #666666; font-family: Arial, Helvetica, sans-serif; background: #ffffff;">Hi,</P><P style="font-size: 12.8000001907349px; color: #666666; font-family: Arial, Helvetica, sans-serif; background: #ffffff;">Im not sure but <SPAN style="font-size: 12.8000001907349px; line-height: 1.5em;">In your case you can use row id as a unique no .</SPAN></P><P style="font-size: 12.8000001907349px; color: #666666; font-family: Arial, Helvetica, sans-serif; background: #ffffff;"> you will get an a unique Combination of record.</P></BODY></HTML> Mon, 15 Jun 2015 09:57:24 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890329#M1002379 2015-06-15T09:57:24Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890330#M1002380 <HTML><HEAD></HEAD><BODY><P>1. If&nbsp; table has primary key, use like where not exists(primary key column) </P><P>2. If table does not have primary key,&nbsp; create composite key by concatenating two or more columns to create unique record.</P><P>Please share sample data&nbsp; if you are not getting still.</P><P></P><P>Thanks,</P><P>Uday.</P></BODY></HTML> Mon, 15 Jun 2015 09:58:07 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890330#M1002380 2015-06-15T09:58:07Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890331#M1002382 <HTML><HEAD></HEAD><BODY><P>What kind of incremental load do you want to do ? </P><P>a. Insert only records</P><P>or</P><P>b. Insert and Update records</P></BODY></HTML> Mon, 15 Jun 2015 10:42:42 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890331#M1002382 2015-06-15T10:42:42Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890332#M1002384 <HTML><HEAD></HEAD><BODY><P>Hi Raju,</P><P></P><P>If you don't have the date columns then try to implement it by the key values i.e check whether the key value exist or not based on this you can implement the incremental load </P></BODY></HTML> Mon, 15 Jun 2015 10:50:47 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890332#M1002384 avinashelite 2015-06-15T10:50:47Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890333#M1002386 <HTML><HEAD></HEAD><BODY><P>Hi Ashish,</P><P></P><P>Second one, Insert and update records.</P><P></P><P></P><P>Rgds,</P><P></P><P>Raju.</P></BODY></HTML> Mon, 15 Jun 2015 12:24:33 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890333#M1002386 Anonymous 2015-06-15T12:24:33Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890334#M1002387 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Avinash,</P><P></P><P>But my data's are keep getting updated in back end. I need to find only updated invoices to do the incremental load.</P><P></P><P></P><P>Help me..</P><P></P><P>Thanks &amp; Regards,</P><P></P><P>Raju Kuppusamy</P></BODY></HTML> Mon, 15 Jun 2015 12:28:13 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890334#M1002387 Anonymous 2015-06-15T12:28:13Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890335#M1002388 <HTML><HEAD></HEAD><BODY><P>kindly share some sample data to figure out the solution,</P><P></P><P></P><P>In fact I am also looking forward hearing from experts on such scenario. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 26 Jun 2015 12:10:08 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890335#M1002388 2015-06-26T12:10:08Z Re: Incremental Load with out Audit columns https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890336#M1002389 <HTML><HEAD></HEAD><BODY><P>Hi Raju,</P><P>How did you manage the incremental load? Could you please share us. Thank you.</P></BODY></HTML> Wed, 02 Sep 2015 07:06:55 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-out-Audit-columns/m-p/890336#M1002389 qlikviewwizard 2015-09-02T07:06:55Z