Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);