topic Update, Insert and Append in QlikView https://community.qlik.com/t5/QlikView/Update-Insert-and-Append/m-p/195162#M55779 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>You can try using NOT EXISTS(ItemID) in code looking like following</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">TablePreviousDay:LOAD ItemID FROM DataBase WHERE Date = Yesterday;<BR />TableToday:LOAD * FROM DataBase WHERE Date = Today <STRONG>AND NOT EXISTS(ItemID)</STRONG></PRE></BLOCKQUOTE><BR /><BR /> <P>Of course, the where statement above is just an example you have to change for your database correct syntax.</P><P>Regards.</P></BODY></HTML> Fri, 26 Mar 2010 13:45:12 GMT Miguel_Angel_Baeyens 2010-03-26T13:45:12Z Update, Insert and Append https://community.qlik.com/t5/QlikView/Update-Insert-and-Append/m-p/195161#M55778 <HTML><HEAD></HEAD><BODY><P>Hi i need some help.</P><P>what i am trying to di is obtain data for one day and then only want to load data the next day for item that do not exist on the previous days load.</P><P></P><P></P><P>thanks</P><P></P></BODY></HTML> Fri, 26 Mar 2010 13:38:45 GMT https://community.qlik.com/t5/QlikView/Update-Insert-and-Append/m-p/195161#M55778 jagjivvt 2010-03-26T13:38:45Z Update, Insert and Append https://community.qlik.com/t5/QlikView/Update-Insert-and-Append/m-p/195162#M55779 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>You can try using NOT EXISTS(ItemID) in code looking like following</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">TablePreviousDay:LOAD ItemID FROM DataBase WHERE Date = Yesterday;<BR />TableToday:LOAD * FROM DataBase WHERE Date = Today <STRONG>AND NOT EXISTS(ItemID)</STRONG></PRE></BLOCKQUOTE><BR /><BR /> <P>Of course, the where statement above is just an example you have to change for your database correct syntax.</P><P>Regards.</P></BODY></HTML> Fri, 26 Mar 2010 13:45:12 GMT https://community.qlik.com/t5/QlikView/Update-Insert-and-Append/m-p/195162#M55779 Miguel_Angel_Baeyens 2010-03-26T13:45:12Z