hello,
i am facing a problem that i dont know how to solve it.
the business analyst from my project gives me a file to import into the data base once per month. The data that i import it is saved also into a historical table. The problem is that many times he gives me the same file to import more than once in a month and i dont know how to delete the data in the historical table that has also the month with the new file that is given. For example i have into my historical table this data:
BU GBU value month
A AA 23 jan
B AB 30 jan
A AC 34 feb
C AA 35 feb
C BB 20 feb
lets say that yesterday he gave me a file that included the last 3 raws with feb.Today he changed his mind and sent me another file with 4 raws also with feb month.
i have to import this file:
BU GBU value month
A AA 12 feb
I AC 13 feb
D AA 17 feb
C BB 21 feb
How do i delete from the historical table only the raws with feb to have the final like this:
BU GBU value month
A AA 23 jan
B AB 30 jan
A AA 12 feb
I AC 13 feb
D AA 17 feb
C BB 21 feb
i can do this manually before importing the data every time but maybe there is a dinamical way to do this. This was only an example with feb month. but i face this problem every month. Maybe someone can help me. thank you!