Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kumarreddy257
Contributor

Error in load script

Hi experts,

Can any one of you help me why this error is coming

15 Replies
MVP
MVP

Re: Error in load script

You don't have Inserts table in your script...

This could be you have dropped this table before this concatenation...

Re: Error in load script

Check that you have already created a table with the name Inserts. If you created such a table, but it has exactly the same fields as another table you created earlier then that table won't be created as Inserts but the data will be added to the first table.


talk is cheap, supply exceeds demand
admin1
New Contributor III

Re: Error in load script

Is the table ' Inserts' tyhe one you are reading from D:\?  do you have the table name in your script?

It is not recognizing that table name - either it has not been loaded yet, it has been dropped or there is a spelling mistake (including capitalization)

pamaxeed
Contributor III

Re: Error in load script

Can you share some additional details?
It seems the Insert table was not created or was just dropped....

Arjunarao
Honored Contributor II

Re: Error in load script

Hi kumarreddy257,

Can you provide us the full sample script to demonstrate your issue to avoid imagination.

kumarreddy257
Contributor

Re: Error in load script

Hi all,

Can you pls find the below script

For each vFile in filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_inserts.qvx')

Inserts:

LOAD *

FROM [$(vFile)] (QVX);

next vFile

Concatenate (Inserts)

LOAD *

FROM

D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd

(qvd);

Store Inserts into D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd);

Drop Table Inserts;

///////////////////Updates////////////////////

For each vFile in filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_updates.qvx')

Updates:

LOAD *

FROM [$(vFile)] (QVX);

next vFile

Concatenate (Updates)

LOAD *

FROM

D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd)

Where not exists(account_key);

Store Updates into D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd);

Drop Table Updates;

MVP
MVP

Re: Error in load script

Try to load only one file using below path..

filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_inserts.qvx') and check whether it's working or not...

pamaxeed
Contributor III

Re: Error in load script

Are you sure that the table INSERTS get created ?

Are you entering in the for each LOOP? Maybe you can add a TRACE statement to see if you entering the loop....

Or just check if the Inserts table is created and add an EXIT Script statement just after the for loop like below:


For each vFile in filelist('xxx')

Inserts:

LOAD *

FROM [$(vFile)] (QVX);

next vFile


EXIT Script;

Cheers,

Patric

MVP
MVP

Re: Error in load script

It looks like the first loop is not lading any content. Open the debugger and single step through the script to see what's happening.

Just noticed that your filelist has no wildcards (both), so it will look for exactly one file matching that path and name. i have a feeling that it does not exists.

Normally the fllelist is a path with wilcards, like

       ...  in FileList('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\*.qvx')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser