Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP Connector Reload Issue

First Query works fine but the second query fails and give different fields missing error every time. Both of them are generated from script builder. This is strange and needs to be resolved ASAP; as I want to use inner join for Incremental Load

[CRMD_ORDER_INDEX]:   // Index table for one-order document
Load
[HEADER] as [HEADER],
[ITEM] as [ITEM],
[PROCESS_TYPE_IX] as [PROCESS_TYPE_IX],
[OBJECT_TYPE] as [OBJECT_TYPE],
[PARTNER_NO] as [PARTNER_NO];
SQL Select PARTNER_NO OBJECT_TYPE HEADER ITEM PROCESS_TYPE_IX from CRMD_ORDER_INDEX
;
STORE * FROM [CRMD_ORDER_INDEX] INTO CRMD_ORDER_INDEX.QVD;
DROP TABLE [CRMD_ORDER_INDEX];

***********************************************************************************************************************

[CRMD_ORDER_INDEX]:   // Index table for one-order document
Load
[HEADER] as [HEADER],
[ITEM] as [ITEM],
[PROCESS_TYPE_IX] as [PROCESS_TYPE_IX],
[OBJECT_TYPE] as [OBJECT_TYPE],
[PARTNER_NO] as [PARTNER_NO];
SQL Select CRMD_ORDER_INDEX~PARTNER_NO CRMD_ORDER_INDEX~OBJECT_TYPE CRMD_ORDER_INDEX~HEADER CRMD_ORDER_INDEX~ITEM CRMD_ORDER_INDEX~PROCESS_TYPE_IX  from CRMD_ORDER_INDEX
;
STORE * FROM [CRMD_ORDER_INDEX] INTO CRMD_ORDER_INDEX.QVD;
DROP TABLE [CRMD_ORDER_INDEX];

0 Replies