topic Re: Do while loop stalling out after condition is met in QlikView

Do while loop stalling out after condition is met

gcharlesworth — Sat, 16 Nov 2024 21:27:34 GMT

Hi all -

Can anyone please tell me why my script seems to be stalling after this Do While loop is complete? My loop is trying to load and concatenate multiple large QVDs from the name range of 2016 to 2019 (each QVD is named "_201*".

The script loads each QVD based on my conditions correctly, but after it loads the 2019 file, the script just stalls and freezes up. I have debugged this several times each time it sames the script has finished, but everything stalls

Are the tables not automatically concatenating thus creating synthetic keys? Any help on this would be greatly appreciated. I have attached a log file as well.

Re: Do while loop stalling out after condition is met

sunny_talwar — Wed, 06 Feb 2019 18:34:12 GMT

Is it possible you have another table in your app before this with the repeating fields and it is trying to create a synthetic key?

Re: Do while loop stalling out after condition is met

pradosh_thakur — Wed, 06 Feb 2019 18:39:11 GMT

Can you load data from your 2016 qvd and 2017 qvd and compare the fields. May be they are different that's why 2016 and 2017 are not concatenating and other are getting concatenated. I think the while loop is fine. Please do a cross check and check the case sensitivity as well..

Re: Do while loop stalling out after condition is met

dplr-rn — Wed, 06 Feb 2019 18:46:09 GMT

I suggest doing a debug and limited load to diagnose whats happening.
I suspect it may not be concatenating. if so force concatenation using one of the techniques mentioned in link below

https://community.qlik.com/t5/QlikView-Scripting/Create-Empty-Table-for-a-Looping-Load/td-p/1087311

Re: Do while loop stalling out after condition is met

gcharlesworth — Wed, 06 Feb 2019 19:14:53 GMT

Hi Pradosh -

This was the correct solution. I forgot that my ID key field was not added until 2017 on and that in previous applications I always hard-code the field names that I need. Adding the specific field names and omitting "ID" let the table concatenate properly and the script ran through successfully. Good catch, thanks!

Gary