I am looking for input on below:
I am having QVD which hold all the historical data. If any new data comes(on Adhoc basis) which need to compare first with QVD. After comparison fresh data details need to be alerted via email and store data into QVD.
Attaching sample file for reference.
Thanks in advance!!
How QVD you want after updating the data? Merge you meant to say
I want to merge the new data with old one. But the new data need to be alerted(2 new records which is having unique entry compare to QVD). Please refer the attachment for reference.
U can create one flag Like
Today() as Flag
whenever you do reload it create today date as a flag u can concatinate with old one and recently loaded records you can filter it by using date in flag field.
I hope you understood.