topic Re: Data loader SQL with Where in using an arrary in App Development

Data loader SQL with Where in using an arrary

SkyTate — Thu, 22 Sep 2022 20:42:04 GMT

I would like to replace the following code in Qlik Sense Data Loader

SQL
SELECT
I_PLT,
DEPTCODE,
LINECODE,
X_LINE_DESC

from m.maslin
WHERE I_PLT in ('02462','02470','04012','04025')
with UR;

With something like this:

set vPlantsToLoad = 02462,02470,04012,04025;

SQL
SELECT
I_PLT,
DEPTCODE,
LINECODE,
X_LINE_DESC

from m.maslin
WHERE I_PLT in '$(vPlantsToLoad)'
with UR;

Re: Data loader SQL with Where in using an arrary

rachel_delany — Fri, 23 Sep 2022 00:14:32 GMT

Your variable needs to match how you've formatted your filter in the first part.

E.g. set vPlantsToLoad = ('02462','02470','04012','04025');

Re: Data loader SQL with Where in using an arrary

SkyTate — Mon, 26 Sep 2022 19:53:31 GMT

I had already tried that. When I do it like that I get the following error.

The following error occurred:

Connector reply error: SQL##f - SqlState: 42601, ErrorCode: 4294967192, ErrorMsg: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "'(''02462'',''02470'',''04012'',''04025'')'" was found following "". Expected tokens may include: "(". SQLSTATE=42601

The error occurred here:

SQL

SELECT

I_PLT,

DEPTCODE,

LINECODE,

X_LINE_DESC

from m.maslin

WHERE I_PLT in '(''02462'',''02470'',''04012'',''04025'')'

Re: Data loader SQL with Where in using an arrary

rachel_delany — Tue, 27 Sep 2022 22:18:37 GMT

Can you include the part of your script where you set the variable?