topic Re: Dynamic Partial Reload for data model ? in QlikView

Dynamic Partial Reload for data model ?

rajuamet — Wed, 25 Nov 2020 16:16:04 GMT

Hi Techies,

I am initiating a partial reload from a batch file. This partial reload is done for a data model. The tricky part is that, I have to switch the partial reload between tables from an excel input. How can I achieve this. Any Ideas???

Re: Dynamic Partial Reload for data model ?

sunny_talwar — Fri, 29 Jul 2016 06:10:30 GMT

Rangaraju Rajappan wrote:

I have to switch the partial reload between tables from an excel input.

Can you elaborate a little more on this?

Re: Dynamic Partial Reload for data model ?

rajuamet — Fri, 29 Jul 2016 06:31:25 GMT

Hi Sunny,

Lets say In data model I have two tables. I am performing partial reload on these two tables based on the input from an excel.

Example:

Input from Excel:

Name Reload Status

Table1 Y

Table2 N

When I perform Partial reload, Table1 alone should reload.

Suppose,

Input from Excel:

Name Reload Status

Table1 N

Table2 Y

Now, When I perform Partial reload, Table2 alone should reload.

Re: Dynamic Partial Reload for data model ?

sunny_talwar — Fri, 29 Jul 2016 06:34:34 GMT

Oh ya, I think this is def. doable using if statement. I guess store the values of your inputs into a variable and do a partial reload only if there is Y

If $(vTable1) = 'Y'

Add/Replace Only

LOAD ....

FROM Table1

ENDIF

If $(vTable2) = 'Y'

Add/Replace Only

LOAD ....

FROM Table2

ENDIF

Re: Dynamic Partial Reload for data model ?

rajuamet — Fri, 29 Jul 2016 07:37:34 GMT

Hi Sunny,

Here I have attached the setup. I have implemented the same logic which you shared. But when I do partial reload no table is being reloaded. (I have given condition to reload table2) .

I guess "partial reload" and "If..Then" wont sync. Am I going wrong or is there any other way to achieve this.

Re: Dynamic Partial Reload for data model ?

sunny_talwar — Fri, 29 Jul 2016 08:50:10 GMT

Give this a try now

Re: Dynamic Partial Reload for data model ?

rajuamet — Fri, 29 Jul 2016 09:18:13 GMT

Awesome Sunny! it is working. Thanks .

Re: Dynamic Partial Reload for data model ?

sunny_talwar — Fri, 29 Jul 2016 09:18:57 GMT

Great, I am glad it does

Best,

Sunny