topic Re: Script is not executing in QlikView

Script is not executing

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

I have exactly two tables with same column names for purchase and sales. when i am clicking on reload button the script is not executing

what will be the reason behind the same?

Re: Script is not executing

tresB — Tue, 19 Sep 2017 05:40:50 GMT

Are you concatenating the two tables or using NoConcatenate ? If not concatenating, they would generate synthetic keys, and that may be hanging up your load. Try concatenating them if the load happens. You could concatenate these two tables and add a Flag field to use it in the front-end set analysis expressions.

Re: Script is not executing

Anonymous — Tue, 19 Sep 2017 05:41:40 GMT

but in your screenshot it is showing 28225 lines fetched.

Re: Script is not executing

ramasaisaksoft — Tue, 19 Sep 2017 06:21:51 GMT

Hi Kaul,

How you are saying, your script is not Executing?(Script execution progress is showing 28255 rows fetched)

i think you are misunderstanding

if you have 2 or more tables with the same field Names(Case sensitive) then Qlikview will by default doing

"Auto concatenate" so that the output will show First table only created (i mean in table viewer you will observer only First table with combination of 2 tables data.)

Ex:-

Tab1:

From ......2016.xlsx; //imagine this table have 20 rows of data

Tab2:

From ......2017.xlsx;//imagine this table have 30 rows of data

After reload the above script,Now the output/Table viewer will show the data like below

Tab1:

z /// But this table will have 50 records of data.

Re: Script is not executing

dinuwanbr — Tue, 19 Sep 2017 06:29:04 GMT

Hi Saksham,

If both the tables are having same no of columns and column names are same then those table are concatenated into same table.(first table will be loaded and second table data will be amended).

To avoid this you have to rename the columns in the second table or use qualify*; in between.

qualify and unqualify

Rgds,

Tharindu

Re: Script is not executing

Anonymous — Tue, 19 Sep 2017 06:34:55 GMT

Plz Use Qualfy and UnQualify

QUALIFY*;

Table1:

LOAD EmployeeID,

[Hire Date],

Office,

[Reports To],

EmployeeName,

Title,

SalesOffice

FROM

UNQUALIFY*;

Table2:

LOAD EmployeeID,

[Hire Date],

Office,

[Reports To],

EmployeeName,

Title,

SalesOffice

FROM

Here the Field of Table 1 and Table 2 are Same

Regards

Tahemas Momin

Re: Script is not executing

andrei_delta — Tue, 19 Sep 2017 13:18:44 GMT

Hello,

The data is concatenating into one single table, usually in the first loaded table that contains the same the with the tables loaded afterwards.

Hope it helped,

Andrei

Re: Script is not executing

Anonymous — Wed, 20 Sep 2017 11:11:09 GMT

I mean to say My script is executing but that window is not automatically getting closed after script has executed, although,i have tick on the option closed when finished.

what may be the reason for the same?

Re: Script is not executing

ramasaisaksoft — Wed, 20 Sep 2017 11:33:52 GMT

So you are saying ,"Script Execution Progress" window is opening

Suggestion 1:-

This is the stage in the script where QlikView establishes the data model and creates the synthetic keys. If you have many synthetic keys, the script will hang at this stage.

I would suggest you load just a small amount of data - either by using "First 10" before each load statement, or by making a "Limited Load" in the script debugger - so you will be able to analyze the data model.

Suggestion 2:-

Normally it won't happens like that, if it happens to all applications just try to un-install the software and install one more time.

check one more time your data model before going to Suggestion 2.

Re: Script is not executing

sudeepkm — Wed, 20 Sep 2017 13:39:07 GMT

you can always Debug with limited records to see what the data model looks like after full reload.

Re: Script is not executing

csillamaglodi — Sat, 08 May 2021 07:29:09 GMT

Hi All,

i have the same issue, so now running the debugger to see what’s causing the problem. I have several tables connected in the script, but so far I haven’t experienced this. Why does it happen that the same script runs okay for several months and then with no changes it just doesn’t close the script execution window?

thank you for your help!