Update, Insert and Append

[jagjivvt]

Hi i need some help.

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.

thanks

[Miguel_Angel_Baeyens]

Hello,

You can try using NOT EXISTS(ItemID) in code looking like following

TablePreviousDay:LOAD ItemID FROM DataBase WHERE Date = Yesterday;
TableToday:LOAD * FROM DataBase WHERE Date = Today AND NOT EXISTS(ItemID)

Of course, the where statement above is just an example you have to change for your database correct syntax.

Regards.