Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

emilinovich
New Contributor

How can i clear all app's test data and load new production data?

HI.

I've created an app with Qlik Sense desktop that loads data from an test ODBC datasource. Now i want to delete all data and load data form a real ODBC datasource. When i change the datasource and reload data, it seems than old data remains in the app.

Thanks in advance.

8 Replies
Employee
Employee

Re: How can i clear all app's test data and load new production data?

Can you go to the load editor and post the script ?

Not applicable

Re: How can i clear all app's test data and load new production data?

Did you try the following

Go to Quick Load --> Replace Data option?

Replace Data : Clear all existing data and replace it with the new data. Sheets and visualizations will be preserved, but not work with the new data.

Not applicable

Re: How can i clear all app's test data and load new production data?

Hello Emilio,

Then i think you haven't clear the old data in your data source. Been that you are not changing data source you have to clear all old data in your data source and upload new data.

Regards

Ema

rdspiess
New Contributor

Re: How can i clear all app's test data and load new production data?

I would think going to your live/production ODBC and doing a reload should work ?

MVP
MVP

Re: How can i clear all app's test data and load new production data?

Hi,

Create ODBC datasource pointing to your production database and change the ODBC connection string in your file and then reload your Dashboard, then you will get the production data in your dashboard.

Regards,

Jagan.

emilinovich
New Contributor

Re: How can i clear all app's test data and load new production data?

doesn't work for me because data are in remote server.

emilinovich
New Contributor

Re: How can i clear all app's test data and load new production data?

i got it to work!

- delete ODBC connector in app

- load again ODBC

MVP
MVP

Re: How can i clear all app's test data and load new production data?

Hi,

Please close this thread by giving Correct and Helpful Answers to the useful posts.

Regards,

Jagan.