problem loading data

[thomasv]

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.

[rubenmarin]

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);