Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

 

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?

 

Contributor III
Contributor III

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

thanks!