Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New data entry details need to be notified

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

6 Replies
Not applicable
Author

Attachment for your reference.

Thanks,

Rohit

Anil_Babu_Samineni

How QVD you want after updating the data? Merge you meant to say

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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

Kushal_Chawda

How would you decide the new records? is based on Product, customer and Purchase?

Not applicable
Author

yes, it is based on three key combination. All the records are unique.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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