topic Re: Partial Reload and for each statement in QlikView

Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 08:11:30 GMT

Hi all,

is the "for each" statement skipped during Partial Reload?

Edit: the problem wasn't in the "for each" statement, it works correctly.

The problem is the initialization of the variable vClassi:

let vClassi = peek('classi');

Thanks,

Massimiliano.

Re: Partial Reload and for each statement

Anonymous — Wed, 24 Sep 2014 08:17:23 GMT

i dont think so.

if For each statement is there in table while partial reloading then it will excute

i am not sure pls let me know if any changes

Re: Partial Reload and for each statement

massimilianoruf — Wed, 24 Sep 2014 08:20:37 GMT

This is the portion of the script:

if IsPartialReload() then

drop Table CROSS_FINAL;

ENDIF

for each K in $(vClassi)

CROSS_FINAL:

add load '$(K)' & [Classe valore] AS INCROCIO_CROSS,

'$(K)' AS CROSS_CONSUMO,

[Classe valore] AS CROSS_GIACENZA,

$(K) AS VALORE

resident CROSS_TMP;

next K

//At this point, the table CROSS_FINAL doesn't exist!

Re: Partial Reload and for each statement

Anonymous — Wed, 24 Sep 2014 08:22:31 GMT

Hi,

it means it is going to ignore the for each script right?

Re: Partial Reload and for each statement

massimilianoruf — Wed, 24 Sep 2014 08:24:16 GMT

Yes...

Re: Partial Reload and for each statement

richard_pearce6 — Wed, 24 Sep 2014 08:59:17 GMT

Hi,

The add command during a partial reload behaves very much like a concatenate. If the table doesn't exisit then there's nothing to add the new data too.. therefore its skipped.

Richard

QlikCentral.com

Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 09:05:40 GMT

Hi Richard,

thanks for the reply but the add command now works fine (also the table was empty).

The problem is the initialization of the variable vClassi:

let vClassi = peek('classi');

Any suggestions?

Thanks in advance,

Massimiliano.

Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 09:12:03 GMT

Good to hear Massimiliano, when I read your text it said the table didn't exist which threw me.

First question would be what was the last table loaded and was the field classi in there?

As you're not defining the table name and row number in the peek statement (which would probably be better practice) the last table is assumed (and the last record of the table).

Have you confirmed what the value is in the data to ensure its not a null or some other value?

Rcihard

Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 09:17:57 GMT

Richard,

this is the portion of code:

CLASSI_TABLE:

replace

load concat (chr(39) & [Classe valore] & chr(39),',') AS classi

resident CROSS_TMP;

let vClassi = peek('classi');

This code works perfectly in full Reloa, but when I try the Partial Reload it doesn't work (the variable is empty after partial reload).

Massimiliano.

Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 09:32:35 GMT

Hi,

I've tested the code and it works fine for both partial and full reloads.

The only question would be the data table it's self. I see its from a resident load. Does that table exist? and have you checked the last record in the table, does it have a value?

Richard

Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 09:46:14 GMT

Hi,

the resident table exists and is the following:

CROSS_TMP:

Replace

LOAD [Classe valore],

A1,

A2,

A3,

B1,

B2,

C1,

C2,

FROM

$(DIRPROGETTOXLS)\SimulazioneLS.xls

(biff, embedded labels, table is [LivelliCross$]);

Thanks in advance,

Massimiliano.

Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 09:48:06 GMT

Did you check the last value? can you share your data?

Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 09:56:20 GMT

The table is ok because the field "classi" is correct...

Re: Partial Reload and variables

Anonymous — Wed, 24 Sep 2014 10:00:02 GMT

Hi,

is the field classi unique in the datamodel? If not you should modify peek by peek('classi', -1, 'CLASSI_TABLE');

Best regards

Stefan

Re: Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 10:12:37 GMT

Ah I see you only have one row in the final table.

I've tested the data using a workbook to load the table and peeked the value no problem both on a partial and full reload. I would need to review your application as I can't replicate the fault.....

Rcihard

Re: Re: Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 10:18:40 GMT

The attachment is a simplified model that works in Full Reload but doesn't work in Partial Reload mode (variable vClassi emplty).

Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 10:27:44 GMT

Hi,

Thanks for the file. I did a full load and checked the variable and then manually cleared the variable and did a partial reload, then leaving the variable did another partial reload.

For all three loads the variable was populated fine. When you say its empty are you checking the variable editor? (Sorry to ask the obvious)

Richard

Re: Re: Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 10:51:14 GMT

Yes, I did exactly the same procedure....

Re: Re: Re: Partial Reload and variables

richard_pearce6 — Wed, 24 Sep 2014 11:07:35 GMT

Hmmm, well I'm all out of ideas. Without being able to replicate the fault its difficult to fix.

The only final thing to suggest is changing the peek to the suggestion above including the name of the table and the row id. That doesn't make any difference in the example as it worked fine for me but you never know.

The other thing would be to test on another machine or perhaps even as extream as a fresh install (personal edition on a private PC) just to see if its not a QV issue.

Regards

Rcihard

Re: Re: Re: Partial Reload and variables

massimilianoruf — Wed, 24 Sep 2014 12:47:53 GMT

Thanks! Now it works!