Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Have one requirement, could any one please suggest any method to achieve:
Excel file:
1. At point of time one excel file
2. Will append new records
3. May delete old records
4. Will not have any date column
Requirement:
1. Load the excel file
2. Stamp date based on reload time
3. append new records if any without deleting old records even though deleted in excel
4. one single QVD
5. QVD should have all historic data with Date field included
Please find the attached excel and QVW for reference.
Hi could any one please let me know the solution for my requirement.
Hi Sasi,
See the attached QVW for a solution.
Hope it helps,
Felipe.
Hi thank your help.
I need to schedule the task in QMC, so every time I run its appending the existing records and the count is increasing.
could you please try to look into the same.
Open up the QMC and go to the 'Task' tab to schedule the app, according to the scheduled time.
Creating reload tasks ‒ Qlik Sense
You need first to import the app in the 'App' tab.
Importing apps ‒ Qlik Sense
Yes I know how to create the task in QMC.
But issue is that using your code if I am reloading with out appending new records or delete existing records.
the total count of records are getting increased.
Sorry Sasi but i didn't understand what happened.
The test i'm doing here is appending the new lines to the QVD with the new reloadtime.
Can you explain it better?
Without appending new records can please try to reload the app.
Try this. It assumes EMP ID is unique.
Hi thank you.
Need to stamp the date for all the records.
and more over if I delete any records from excel qvd is also deleting the files.
