Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to update 1 table out of many

I have a snowflake data model with 10 tables, but I don't want to run the entire script to update all 10 tables, rather I want to update only 1 or 2 tables on a regular basis.  How do I do that?

4 Replies
Highlighted

Hi John. Try this steps:

1) At the end of your script, save the static tables to qvd files with Store statement.

   STORE Currencies  INTO [lib://yourspace:DataFiles/Currencies.qvd] (qvd);

If tables don't change anymore, comment this section.

2) On next run of script, you can load tables from that QVDs.

Currencies:
LOAD * FROM [lib://yourspace:DataFiles/Currencies .qvd] (qvd);

 

Regards, Fernando

 

Highlighted
Contributor III
Contributor III

Good point, however, I am not using QVDs and I am pulling tables straight from server.  Is there a way to refresh only certain tables rather than all of them?  Or should I change my process to create QVDs from now on?

 

Highlighted

Highlighted
Contributor III
Contributor III

This may work for me...I'll give it a try.

thanks!