Discussion Board for collaboration on QlikView Scripting.
I have the following SQL query:
case when (select id from table1 where id=number) is null then 'Not Exists'
number,name from table2;
I have created 2 QVD files with table1.qvd and table2.qvd.
I knew only this:
Any help is greatly appreciated.
Go to Solution.
LEFT JOIN (Table1)
Number as id,
If(IsNull(Name), 'Not Exists', 'Exists') AS Status
DROP TABLE Table1;
Hope this helps you.
Load id as number
Load if( exists(number),'Exists','NotExists') as XXXX,
thank you phaneendra
thanks jagan mohan. It worked.