topic Re: Qlik Sense SAP Connector Issue in App Development

Qlik Sense SAP Connector Issue

panipat1990 — Fri, 04 Mar 2016 07:32:01 GMT

Hi Team,

i am facing one issue when i implement delta load in qlik sense during SAP Data Extraction.

Where clause query on date filter is not working properly .

Please help me on this and would appreciate if you provide the syntax for how we can write the query in qlik sense for SAP Delta Load.

waiting for response !!!

Thanks

Gourav

Re: Qlik Sense SAP Connector Issue

chrisjbishop — Fri, 04 Mar 2016 07:50:03 GMT

Hi Gourav,

Which SAP connector are you using? Is it possible to see your where clause?

Is this helpdful?

T1:
SQL SELECT PKey, Details
FROM YOUR_TABLE
WHERE
ModificationTime >= #$(LastExecTime)#
AND
ModificationTime < #$(ThisExecTime)#;

CONCATENATE
LOAD PrimaryKey, Details
FROM T1.QVD
WHERE
NOT EXISTS(Pkey);

Inner Join SQL
SELECT PKey
FROM YOUR_TABLE;

IF ScriptErrorCount = 0 THEN
STORE T1 INTO T1.QVD (qvd);
LET LastExecTime = ThisExecTime;
END IF

Chris.

Re: Qlik Sense SAP Connector Issue

panipat1990 — Fri, 04 Mar 2016 08:21:23 GMT

Thanks Chris.

i am using SAP Connector 6.1 which is most current version.

Below is the Where clause i am using in Load script while extraction from SAP system.

where

ModificationTime > '$(vLast_Date)';

Regards

Gourav

Re: Qlik Sense SAP Connector Issue

panipat1990 — Fri, 04 Mar 2016 09:21:21 GMT

Hi Chris,

Please check the script which i have defined in QLIK SENSE script editor when i extracted the data from SAP Source.

Sales:

LOAD

Customer_ID,

Modified_Date;

SELECT

Customer_ID,

Modified_Date

FROM Table

where Modified_Date>= '$(vLast_Date)';

// Customer_ID='1001';

when i do filer on Customer ID basis then where clause is working fine and gives me perfect result.

But when i do filter on Modified_Date then this where clause is not working , it is not filtering out the data.

i don't know may be the syntax of comparing with Date field is different in Qlik Sense.

Please help/Guide me on this.

Thanks

Gourav