Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
the resident table exists and is the following:
CROSS_TMP:
Replace
LOAD [Classe valore],
A1,
A2,
A3,
B1,
B2,
C1,
C2,
D
FROM
$(DIRPROGETTOXLS)\SimulazioneLS.xls
(biff, embedded labels, table is [LivelliCross$]);
Thanks in advance,
Massimiliano.
Did you check the last value? can you share your data?
The table is ok because the field "classi" is correct...
Hi,
is the field classi unique in the datamodel? If not you should modify peek by peek('classi', -1, 'CLASSI_TABLE');
Best regards
Stefan
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
The attachment is a simplified model that works in Full Reload but doesn't work in Partial Reload mode (variable vClassi emplty).
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
Yes, I did exactly the same procedure....
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
Thanks! Now it works!