topic problem loading data in App Development

problem loading data

thomasv — Fri, 11 Jun 2021 12:55:40 GMT

Hello,

I have a little car problem when I have a little piece of code that allows me to create data from the previous 7 days, the problem is that if the data already exists, well it is doubled, and I therefore want to avoid that.

If anyone has any advice or a tip, thank you.

Re: problem loading data

rubenmarin — Sat, 12 Jun 2021 08:06:29 GMT

Hi, you can use Exists() to check if a value already exists, so you can first load the data you want to prorize (the last 7 days or the previously loaded data) and then load the other checking with Exists:

TableWithDataToKeep: LOAD Key, OtherFields... TableWithMoreData LOAD Key, OtherFields... Where not Exists(Key);