How to update 1 table out of many

[john_henry]

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?

[Fernando_Fabregas]

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

[john_henry]

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?

[avinashelite]

you could try with Partial reload 

https://community.qlik.com/t5/New-to-QlikView/What-is-meant-by-partial-reload-What-is-its-use-Please...

[john_henry]

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

thanks!