How can I replace my existing list with new one so that D4 should not appear in the list. why i am raising this question is because when I am importing the new list, D4 is still appearing in it which is actually not in the new list, kindly advise:
Until and unless, the previous item D4 is deleted from the list before you run the import action, it will remain in the list. Question is how to identify that D4 is not there in the updated file.
One approach is to delete all content of the second list before you do the import. But that has a risk of losing data associated with D5.
The other approach (a bit roundabout) is to identify from the source data if an item exists in the new data set or not. Create a module with one line item called initialise (can be formatted as anything you want, preferably text). Populate that as blank before you run the import. Once you run the import, populate the line item against the list to identify which of the items exist. You can simply populate this by the list item name itself. If some items don't exist, use a delete process after the import is run to delete them from the list.
Thanks for the reply, only one question i have is that assuming i am using time scale in my module (monthly) so when i delete my previous list and upload the new one will my prior months data remain their or i will lose it also.
This is because D4 is already a member of the CatB list, if you load the new file, it either updates new entries or updates any matching entries, it wouldnt delete any list item in the list even if you upload a blank file , in order to do update you need to set a delete action first, you can do using a boolean and then delete using selection action and then perform the import