MATCH SYNTAXE

[theboss-123]

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]

Hi

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]

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 · Accepted solution]

@theboss-123 like this.

Load

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

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

SQL SELECT *
FROM SEED.PORDER ;