Script Error - table not found

[#1]

Dear Qlik-Community!

Within a script execution on our QlikView-Testserver I am getting an script error "Table not found":

The whole script part is:

LOAD %VKORG as %VKORG.VBAK,
  num( %VKORG ) as SEC_ORGANISATION
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );
;

DistributionGroups:
LOAD %VKORG as %VKORG.VBAK,
     Description,
     DistributionGroup
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );
;

////to delete and move to datamodel:
maratemp:
load *
, if( index( [%PRODH], 'PA0101' ) = 1, 'Vacuette Tubes'
, if( index( [%PRODH], 'PA010711' ) = 1, 'Needles / Luer Adapter / Blood Collection Sets'
, if( index( [%PRODH], 'PA01071211' ) = 1 or index( [%PRODH], 'PA01071204' ) = 1 or index( [%PRODH], 'PA01071205' ) = 1 or index( [%PRODH], 'PA01071206' ) = 1, 'Quickshield'
, if( index( [%PRODH], 'PA01071209' ) = 1, 'Premium Safety Needle System (Tube Touch)'
, if( index( [%PRODH], 'PA010801' ) = 1, 'Mini Collect Tubes'
, 'no Group defined' )))))
as [SalesReportGroupProduct.MARA]

, if( index( [%PRODH], 'PA0101' ) = 1, 1
, if( index( [%PRODH], 'PA010711' ) = 1, 2
, if( index( [%PRODH], 'PA01071211' ) = 1 or index( [%PRODH], 'PA01071204' ) = 1 or index( [%PRODH], 'PA01071205' ) = 1 or index( [%PRODH], 'PA01071206' ) = 1, 3
, if( index( [%PRODH], 'PA01071209' ) = 1, 4
, if( index( [%PRODH], 'PA010801' ) = 1, 5
, 0 )))))

as [SalesReportGroupProductID.MARA]

resident MARA;
drop table MARA;
rename table maratemp to MARA;

The strange thing is, that I have the same qvw.file on our QlikView Productive-system - where the script load works without any errors and the MARA-table is existing in the datamodel...

Thank you for your help!

Best regards,

Barbara

[Anonymous]

Hi,

I am assuming that this code:

LOAD %VKORG as %VKORG.VBAK,
  num( %VKORG ) as SEC_ORGANISATION
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );

;

should be:

MARA:

LOAD %VKORG as %VKORG.VBAK,
  num( %VKORG ) as SEC_ORGANISATION
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );
;

[ali_hijazi]

the only thing I would think of is that automatic concatenation occurred at some point of your script

where you loaded everything from MARA with some condition then you dropped the table MARA and then renamed that new table; this would result in automatic concatenation if you didn't use NOCONCATENATE

example:

MARA:

Load * from QVD_File.qvd(qvd);

temp:

Load * resident MARA where some_condition=true;

drop table MARA;

then this will result in no table since automatic concatenation has been applied and the temp table doesn't really exist

[#4]

yes - there is a binary load:

the MARA table in the binary load table is ok - i do not get there any script errors..

[avinashelite]

Please check your binary load file once ....whether it has all the necessary fields and tables in it

[#6]

Hi,

thank you for your Input - but I am afraid, this is not working too --> I am getting an error message "field %PRODH not found" - I think it is searching in this Excel-file for a field named %PRODH.
acutally there is no real Connection between this Excel-file and the MARA-table

[Anonymous]

Perhaps that is the issue

[#8]

HI,

I changed %VKORG.VBRK to %VKORG.VBAK - now I get 14 lines... somehow it works with this script in the productive System..

LOAD %VKORG as %VKORG.VBAK,
  num( %VKORG ) as SEC_ORGANISATION
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );
;

DistributionGroups:
LOAD %VKORG as %VKORG.VBAK,
     Description,
     DistributionGroup
FROM
[..\..\02 Extern\steuernde_Daten_Vertrieb\DistributionGroups.xlsx]
(ooxml, embedded labels, table is Tabelle1)
where exists( %VKORG.VBRK, %VKORG );
;

[Anonymous]

hey you are using resident load with table name MARA but I am not able to find out table MARA in your script.

Make sure table MARA will be there before starting the resident load.

Regards,

Sandip Satbhai

[#10]

hi!

but isn't MARA loaded with the binary load of

[..\..\05 datamodel\sd\datamodel_SD_DailyJournal.qvw];

within this qvw-file MARA is loaded:

LOAD *,
%MATNR as x%MATNR
FROM $(Data)\MARA.QVD (qvd)

I tried to load MARA again  - before maratemp, but this causes problems with the whole datamodel and no values were available after that.

best regards

[Gabriel]

Hi,

Usually when you have error of Table Not Found, I will suggest you check that you don't have AUTO CONCATENATE happening.

So check your script, debugging is the best solution. Comment each table out and load previous table until you can figure out which this is happening.

Alternative is to attach a sample of your file

Hope this help.