topic Re: Upload data monthly and update the dashboards in Connectivity & Data Prep

Upload data monthly and update the dashboards

torraroger — Wed, 13 Nov 2019 11:25:34 GMT

Hi all,

My question is simple:

I have created a data model with many tables in excel file format. These tables are extracted from an ERP (Kinaxis).

I want to know if it is possible to exctact the tables periodically, for example monthly, from the software (Kinaxis) and that Qlik sense automatically detect the tables, load them and update the dashboards created with the same previous relationships.

I want to analyse monthly usage of some resources, and it would be great if I could automatize the process: so I just have to extract and save the files, refresh Qlik sense and get the dashboards updated.

Many thanks in advance!!

Re: Upload data monthly and update the dashboards

dplr-rn — Wed, 13 Nov 2019 15:58:45 GMT

Not sure what you mean by automatically detect tables.

once the script to load the excel is setup the data can change and qlik will automatically ingest it. Data structure change is more complex. this may not be automatically possible

Re: Upload data monthly and update the dashboards

torraroger — Wed, 13 Nov 2019 16:02:39 GMT

@dplr-rn

I mean, I want to update every month the data.

This update means extracting the data from the software and charge the tables into Qlik.

Can I download the data from the software in a specific file that Qlik can recognize and delete the previous month data and switch it from the new one

Re: Upload data monthly and update the dashboards

dplr-rn — Wed, 13 Nov 2019 16:04:43 GMT

Yes. as long as the excel structure remains the same.

Re: Upload data monthly and update the dashboards

torraroger — Wed, 13 Nov 2019 16:17:06 GMT

Thanks!! And how can I do it?

Re: Upload data monthly and update the dashboards

dplr-rn — Wed, 13 Nov 2019 16:20:53 GMT

Suppose your excel file is called DB Extract.xlsx

And You always put this in \\networkdrive\DBExtract\ folder

create the connection to this folder and load the data from the excel as per usual.

in the qlik server set reload schedule for qlik sense app. e.g. daily

so whenever the excel is updated and the app is reloaded next the data will be updated into qlik