topic Re: Exclude specific records from a SQL call in QlikView

Exclude specific records from a SQL call

JACKNIEKERK — Fri, 21 Aug 2020 11:40:23 GMT

Reading a datafile on 1 key, ITEMNUMBER,

contains numbers like 12345678 but some like 12.345678

need syntax to say like

SQL select * from PRODUCT where ..........................ITEMNUMBER does not contain a '.' (dot)

thanks for advice

Re: Exclude specific records from a SQL call

sunny_talwar — Fri, 21 Aug 2020 11:54:06 GMT

May be this

SQL SELECT * FROM PRODUCT WHERE INSTR(ITEMNUMBER, '.') = 0;

Re: Exclude specific records from a SQL call

JACKNIEKERK — Fri, 21 Aug 2020 12:21:49 GMT

Hello got error

SQL##f - SqlState: 37000, ErrorCode: 0, ErrorMsg: [Pervasive][ODBC Client
Interface][LNA][Pervasive][ODBC Engine Interface]Invalid scalar function:
INSTR.
SQL SELECT * from PRODUCT WHERE INSTR( ITEMNUMBER ,'.')= 0

Re: Exclude specific records from a SQL call

Kushal_Chawda — Fri, 21 Aug 2020 12:50:09 GMT

try below

SQL SELECT * FROM PRODUCT WHERE ITEMNUMBER NOT LIKE '%.%';

Re: Exclude specific records from a SQL call

JACKNIEKERK — Fri, 21 Aug 2020 12:54:47 GMT

Thanks for advice