Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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!!
Rohit
Attachment for your reference.
Thanks,
Rohit
How QVD you want after updating the data? Merge you meant to say
Hi Anil,
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.
Thanks,
Rohit
How would you decide the new records? is based on Product, customer and Purchase?
yes, it is based on three key combination. All the records are unique.
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.
-Nagarjun