topic Re: Issue with where Exists clause in Qlik SaaS in App Development

Issue with where Exists clause in Qlik SaaS

Apoorva_sd — Mon, 11 Nov 2024 22:16:35 GMT

Hello,

I am trying to load the following inline table and then load only load those IDs from this table in the next table but I get a "0 lines fetched" message for the second table. This code is working fine in the client managed version, but not in the cloud. Any help on this?

Table1:

Load * Inline

[ Product Name, Product ID, Product Name New

One, 1R, First

Two, 1-1R, First

Three, 2R, Second

Four, 2-1R, Second

]

Qualify*;

Unqualify [Product ID];

Load A as [Product ID],

B as Plant,

C as Location,

where exists(Product ID, A);

Select A,

From Table2;

This is the sample script that resembles my original script where I am trying to load only those product IDs that are in the above inline table from SAP.

So, when I use A in the front end it should only contain - 1R, 1-1R, 2R and 2-1R. But, I see other values that are in A.

Thank you,

Apoorva

Re: Issue with where Exists clause in Qlik SaaS

treysmithdev — Tue, 12 Nov 2024 03:07:44 GMT

I have seen some differences between the SAP connectors, which has been due to the differences between ODBC (QSEoW) and JDBC (Qlik Cloud).

My recommendation would be to load Table 2 without the Exists condition and see if the values associate. Also take a look in the data preview in the data model view.

I would do this test including the Load statement and with just the SQL statement. Reason being that Qlik does some typing magic during the Load statement that may not present itself when just doing the SELECT.

Example:

With

Load A as [Product ID], B as Plant, C as Location, D, E ; Select A, B, C, D, E From Table2;

Without

SQL SELECT A as "Product ID", B as Plant, C as Location, D, E From Table2;

Re: Issue with where Exists clause in Qlik SaaS

Muthukumar_77 — Tue, 12 Nov 2024 04:38:46 GMT

Try below script,

Table1:

Load * Inline [

Product Name, Product ID, Product Name New

One, 1R, First

Two, 1-1R, First

Three, 2R, Second

Four, 2-1R, Second

];

Table2:

Load A as [Product ID],

B as Plant,

C as Location,

E Where Exists([Product ID],A);

Select A,

From Table2;

Re: Issue with where Exists clause in Qlik SaaS

Apoorva_sd — Tue, 12 Nov 2024 23:35:23 GMT

Hello,

Thank you for the response! The values do associate when I do not use the "Exists" function.

I had to save the table I loaded from SAP to a QVD and then loaded the data from this QVD where I applied the where exists clause, that worked. So, the issue has been resolved.

Thank you.