topic Re: Update Data File in Connectivity & Data Prep

Update Data File

mrainey18 — Thu, 09 Feb 2017 17:31:11 GMT

I have an excel spreadsheet which I create and update with a macro. When I go to the data manager and load the data in, my apps are still pulling from the old data file. How do I get them to pull from the new data that I uploaded?

Note: When I view the data through the data manager I can see the new data that the macro added.

Re: Update Data File

Anonymous — Thu, 09 Feb 2017 20:20:50 GMT

Does the macro also save the excel file?

Excel will only keep new data in memory, you need to save it in order for the data to exist on disk for qlikview to pick up

Re: Update Data File

mrainey18 — Thu, 09 Feb 2017 21:58:56 GMT

Yes it saves the file. I tried doing it two ways: one deleting the file and creating another one with the same book name and sheet name, and then opening the file and just saving it again.

Both times resulted in Qlik pulling from the old file.

Re: Update Data File

rwunderlich — Fri, 10 Feb 2017 00:22:40 GMT

And you pressed the "Load Data" button in Qlik Sense?

-Rob

Re: Update Data File

Anonymous — Fri, 10 Feb 2017 10:58:18 GMT

If you are using the 'Drag and Drop' file upload feature in Data manager then a copy of the file will be stored locally on the Qlik Sense Server.

If your file is constantly updated you or your sense administrator needs to create a Lib connection to the original file location and repoint your load script to this location.

The Sense Help will guide you through this;

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/adding-data.htm

Re: Update Data File

mrainey18 — Fri, 10 Feb 2017 13:22:30 GMT

Yes.

Re: Update Data File

mrainey18 — Fri, 10 Feb 2017 13:29:20 GMT

I am not dragging and dropping the file in. I upload it using the data up loader. So: Add Data-->Connect my Data-->Excel Files-->Navigate to the file-->Prepare data-->Load Data

After I load more data on to the excel file I go to the Data Manager, find the table I want to refresh and click load data.

Re: Update Data File

Anonymous — Fri, 10 Feb 2017 18:35:41 GMT

Either way the file will load up to the sense server and be stored on the server as is, you would constantly need to upload the refreshed data everyday.

Sent from my Samsung Galaxy smartphone.

Re: Update Data File

mrainey18 — Fri, 10 Feb 2017 18:53:25 GMT

So if I pulled my data from a SQL server, would that fix my problem?

Re: Update Data File

Anonymous — Mon, 13 Feb 2017 10:38:04 GMT

Yes, if the SQL server contains the continually updated data then this would solve your issue.

It would still require a lib connection setup in Sense.