topic Re: MATCH SYNTAXE in App Development

MATCH SYNTAXE

theboss-123 — Thu, 17 Nov 2022 00:14:45 GMT

Hello would like to only just the value related to AO011 and BM001 but i got error can check please if the syntaxe below is correct

Load

"CUR_0" as "Devise",
"ORDDAT_0",
"POHFCY_0" as Dim8;

SQL SELECT *
FROM SEED.PORDER where match ([POHFCY_0],'AO011','BM001');

MayilVahanan — Thu, 17 Nov 2022 01:53:15 GMT

Match is Qlik function, for SQL, try with "in" like below

Load

"CUR_0" as "Devise",
"ORDDAT_0",
"POHFCY_0" as Dim8;

SQL SELECT *
FROM SEED.PORDER where [POHFCY_0] in ('AO011','BM001');

theboss-123 — Thu, 17 Nov 2022 13:45:05 GMT

Hi Dear,

First I would like to thanks for your assist and reply secondly i tried ur syntaxe but the resultat it returns all site.

BrunPierre — Thu, 17 Nov 2022 17:32:15 GMT

Load

"CUR_0" as "Devise",
"ORDDAT_0",
"POHFCY_0" as Dim8

Where match ([POHFCY_0],'AO011','BM001');

SQL SELECT *
FROM SEED.PORDER ;