Error in load script

[Anonymous]

Hi experts,

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

[MK_QSL]

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

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

[Gysbert_Wassenaar]

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.

[Anonymous]

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]

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

[qlikviewwizard]

Hi kumarreddy257,

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

[Anonymous]

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;

[MK_QSL]

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]

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

[jonathandienst]

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')