Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have around 25 tables in my data model.
I usually rename few of the fields from few tables to use it in front end.
If i do this, then i have to load complete 25 tables for few field renames.
Is there a way to load only the changed field tables on reload, without loading all the tables?
I know about partial reload, but that is for adding new tables.
But here i am changing the field names of few fields in existing table.
How can we load only those tables on reload?
How frequently you change the fields names in the script, if frequency is low, then there is no harm in reloading all the tables.
Hi Angad,
Thanks for the reply.
The frequency is not that low, but is there a way to avoid full load?
I just want to know, if there is any method to avoid this.
As per my knowledge, I do not think there is a direct way to identify only the renamed column tables and then just reload them.
Do you rename the field from the LOAD statements itself or you use the in-built RENAME statement in qlikview?
Workaround can be, to binary load your data model into another qlikview file and in the new one add the RENAME statements. Though this will still reload all tables, but will be relatively faster.
P.S the workaround is not tested by me.
Hope this will be helpful.
Thanks,
Singh
There is option of "Partial Reload"...you can use that and it will reload only things which you ahve changed
Hi,
Partial reload is the option or you can comment the old field and reload only those fields only. And another way is load another table with partial load and join this table to the old one or concatenate the table. But better you rename the old field with new and do partial reload.
Use
Replace
Load * From Location;
Regards
Anand