isnull()

[mahitham]

Hi Experts,

Can any one please help me to convert below two sql logics into Qlik.

SELECT

ID,

ISNULL(CAST (RESTI.KEY as NVARCHAR(1024))," ") KEY

FROM

Thanks in advance.

[jyothish8807 · Accepted solution]

Hi Mahitha,

Try like this:

Load

ID,

if(isnull(PKEY)=-1,' ',PKEY) as PKEY,

if(isnull(DESCRIPTION)=-1,' ',DESCRIPTION) as DESCRIPTION

from

<>