Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
Hi Agustin,
Thank you for your idea - but still the same error..
Best Regards,
Barbara
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
Hi Barbara, if you set an "exit script;" after Binary sentence, it loads the MARA table?
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