Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

udaya_kumar
Valued Contributor

Is there a way to load only one or two table fields on reload?

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?

Tags (2)
5 Replies
Not applicable

Re: Is there a way to load only one or two table fields 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.

udaya_kumar
Valued Contributor

Re: Is there a way to load only one or two table fields on reload?

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.

Not applicable

Re: Is there a way to load only one or two table fields on reload?

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

saumyashah90
Valued Contributor

Re: Is there a way to load only one or two table fields on reload?

There is option of "Partial Reload"...you can use that and it will reload only things which you ahve changed

Re: Is there a way to load only one or two table fields on reload?

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

Community Browser