topic How to write a subquery with "if else" condition in QlikView

How to write a subquery with "if else" condition

Fri, 01 Mar 2013 05:45:05 GMT

Hi friends,

I have the following SQL query:

select

case when (select id from table1 where id=number) is null then 'Not Exists'

else 'Exists'

END case,

number,name from table2;

I have created 2 QVD files with table1.qvd and table2.qvd.

I knew only this:

Load number,

name

FROM

(qvd);

Any help is greatly appreciated.

Re: How to write a subquery with "if else" condition

phaneendra_kunc — Fri, 01 Mar 2013 05:56:32 GMT

Try this

Table1:

Load id as number

FROM

(qvd);

Table2:

Load if( exists(number),'Exists','NotExists') as XXXX,

name

FROM

(qvd);

Re: How to write a subquery with "if else" condition

jagan — Fri, 01 Mar 2013 06:29:30 GMT

HI,

Try this

Table1:

LOAD

FROM Table1.QVD;

LEFT JOIN (Table1)

LOAD

Number as id,

Name

FROM Table2.qvd;

Data:

LOAD

id,

Name,

If(IsNull(Name), 'Not Exists', 'Exists') AS Status

RESIDENT Table1;

DROP TABLE Table1;

Hope this helps you.

Regards,

Jagan.

Re: How to write a subquery with "if else" condition

Mon, 04 Mar 2013 11:09:56 GMT

thank you phaneendra

Re: How to write a subquery with "if else" condition

Mon, 04 Mar 2013 11:10:37 GMT

thanks jagan mohan. It worked.