This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have two files .One is historical file and the other one is current file. as in below screenshot.
Historical file :- where I have Jan,feb and March data.
Every month I get a new file and I need to append this to historical file.
New file :- Again with March and feb data.
I want to delete existing feb and march data from historical file and append new file data to historical file.Is there a way to do that automatically. Because I would be getting the new file as a quarterly or monthly data. Hence wanted to delete the old data which was already loaded so that there is no duplication.
Or if there is any update to the numbers to old month data,I need to delete the entire data for old month and append the old month data from new file.
So in historical file we can have "Haya,ramni,babitha and sham" as part of "March and Feb " data.
But in new file it can be some other name as well.So in this case I want delete the entire rows for March and feb if we have data for the same months in new file and append the new data.Do we have any solution to do the same?. Deleting or filtering out historical file for the distinct date values in new file as a loop?.
So if you want to remove any March observations when you have new March data (even when the list of names differs), then remove "Name" as a join field from my solution. If you only join on date to filter the unique date results and union that to the new records you'll have that solution.