I believe that when you use the Replace options, it replaces intersections for which you have data in the new file you're loading, but if you happen to have an intersection in the original data that is not replaced in the new data, the original data stays in the application. What I usually do is go to the database management and clear all data in the specific scenario.year.period that I want to replace before uploading the new data.
Thanks for the response. I've done some research on this.
For each entity in the data file to be loaded, all accounts, intercompany partners (ICP) and custom 1-4 are cleared for the period and year to be loaded.
The problem is, the entity in which I'm loading data is present in the historic data and the actuals data. So, I believe it should be replaced. Correct?
I just checked and realised that there's zero data in the entities. Thanks Dany for guiding me to the answer.
I did mix up Replace and Merge, sorry about that