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

[t_chetirbok]

Hi!

you should write NOCONCATENATE

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:

noconcatenate
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;

[#3]

Hi Tatsiana,

Thank you 🙂 but unfortunately it didnt worked.. the only difference was, that the script loading was executed till the end and didnt break off..

best regards

[agustinbobba]

Hi Barbara!,

Try to name all the tables and see if you has got some tables with the same structure, i mean the same fields. You can use NoConcatenate before the table names to prevent qlikview concatenate your tables with the same structure.

NoConcatenate

MARA:

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

;

NoConcatenate

DistributionGroups1:

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

NoConcatenate
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:

NoConcatenate

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;

Best regards,

Agustin

[#5]

Hi Agustin,

Thank you for your idea - but still the same error..

Best Regards,

Barbara

[agustinbobba]

Hi Barbara,

The Mara Table is load from the binary or the QVD?

You mention above in a comment "the MARA table in the binary load table is ok - i do not get there any script errors." and then you said "but isn't MARA loaded with the binary load of [..\..\05datamodel\sd\datamodel_SD_DailyJournal.qvw];"

Best Regards,

Agustin

[rubenmarin]

Hi Barbara, if you set an "exit script;" after Binary sentence, it loads the MARA table?

[#8]

Hi all!

Thank you all for trying to help me.

The error was somewhere completely different - we have one part in the script, tracking all changes and the comments had problems to get closed. That's why the binary-load on the following script part wasn't able to start...

Best Regards,

Barbara