Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Having a bit of trouble with an error message that keeps getting throw up when trying to filter data from two tables using WHERE NOT EXISTS.
I load the first table fine:
vbup:
LOAD VBELN&':'&POSNR as EXCSalesOrder,
LFSTA
where LFSTA = 'C'
;
SELECT VBELN,
POSNR,
LFSTA
FROM VBUP;
// STORE * FROM [VBUP] INTO [LIB://FolderConnection/VBUP.qvd];
// DROP TABLE [VBUP];
Then i go to load the second table which is where i have the WHERE NOT EXISTS:
[OOH]:
LOAD
VERKAUFORG as Plant,
REPORTJAHR as [Reporting Year],
REPMONAT as [Reporting Month],
VBELN&':'&POSNR as [Sales Order],
MATNR as [Material Number],
SOLDTO as [Customer ID],
SOLDTO_NAME as [Customer Name],
PSTLZ as [Customer Postcode],
MAKTX as [Material Description],
GEKLA as [Material Group],
BESKZ as [Proc Type],
PROFCTR as [Profit Center],
ZBSTR as [Business Stream],
NETWR as [Sales Value],
MENGE as Quanitity,
AUDAT as [Order date],
KDWT as [Customer required date],
WADAT as [GI Date],
ZUSA as [Promise Date]
where BESKZ = 'E' /
and
NOT EXISTS (EXCSalesOrder,VBELN&':'&POSNR)
;
SELECT VERKAUFORG,
REPORTJAHR,
REPMONAT,
VBELN,
POSNR,
MATNR,
SOLDTO,
SOLDTO_NAME,
PSTLZ,
MAKTX,
GEKLA,
BESKZ,
PROFCTR,
ZBSTR,
NETWR,
MENGE,
AUDAT,
KDWT,
WADAT,
ZUSA
FROM ZSOOH
;
// STORE * FROM [ZSOOH] INTO [LIB://FolderConnection/ZSOOH.qvd];
// DROP TABLE [ZSOOH];
DROP Table vbup
And i get this error message:
that looks like an issue with your DB call.
check similar issue
https://community.qlik.com/t5/New-to-Qlik-Sense/Script-Error/td-p/1124442
that looks like an issue with your DB call.
check similar issue
https://community.qlik.com/t5/New-to-Qlik-Sense/Script-Error/td-p/1124442