I have two folders, extract and transform.
Inside these folders are different qvd sheets that are getting updated information from sql server. The qvd has updated timestamps when the tasks are ran.
How can you modify it to add new data to pull from sql ?
Right now, these are run on tasks automatically so I want to continue that to get new data.
I'm able to pull data manually from sql and create new qvd files, but then the data are not update automatically like the other qvd files.
"I'm able to pull data manually from sql and create new qvd files, but then the data are not update automatically like the other qvd files. "
From the above I take it you are using Qlik to STORE new qvd? If so, this same app needs to be on a schedule. This is normally done via QMC.
Hopefully this helps a little.
I will try to steer you.
1) Do you have any current operational QlikView or Qlik Sense apps that connects to your sql db, extracts data and stores the data into qvd's?
2) Are you working in a desktop environment or server?
3) If it is a server environment, are you a Qlik Administrator?
You need to create a new task to reload this file:
"You then have data load editor load these fields with new information."
So what the tasks do is:
The 1st task creates the qvd's and the 2nd task updates the app.
Is it at all possible to share a screen?