Discussion board where members can get started with Qlik Sense.
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?
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);
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?
you could try with Partial reload
This may work for me...I'll give it a try.