I need to import a csv file, which gets updated every 15 minutes. The updated csv file may contains the data from past, ie. the current csv file contains data from 20-04-2018 2pm-3pm, then the next csv file may contains data from the past 18-04-2018 10AM-11AM.
I notice that if the latest csv file contains newer data (timestamp newer) then the histories records are imported. If the data is older, the histories records are not imported. Such as above case, the later csv file will not be imported.
I have played with a few settings such as “ignore duplicate timestamps” “ignore duplicate records” “clear history when older” … but none of them are relevant.
Could anyone give me some help please? Thanks.