topic Re: is null issue in QlikView

is null issue

Thu, 09 May 2013 11:42:07 GMT

hi all i have a script below:

table 1:

id value

a 10

b 15

c 20

table 2:

id category

a xyz

Desired output is as :

final:

id value category

b 15

script is :

test:

load id, value from table 1;

left join

load id, category from table 2;

final:

load id, category, value resident test where isnull(category);

the output i get is:

id value category

b 15

c 20

please help how to get Desired output

thanks in advance

Re: is null issue

Gysbert_Wassenaar — Thu, 09 May 2013 11:46:37 GMT

Replace the left join with an inner join (or right join)

test:

load id, value from table 1;

INNER join

load id, category from table 2;

Re: is null issue

Thu, 09 May 2013 11:53:42 GMT

//Use the below script to get the desired output

table1:

LOAD * INLINE [

id,value

a, 10

b,15

c,20

];

table2:

LOAD * INLINE [

id,category

a,xyz

];

RIGHT JOIN (table1)

LOAD *

RESIDENT table2

WHERE category='';

DROP TABLE table2;

Re: is null issue

er_mohit — Thu, 09 May 2013 12:28:59 GMT

Try this

Table1:

LOAD * INLINE [

id, value

a, 10

b, 15

c, 20

];

Inner Join

Table_2:

LOAD * INLINE [

id,category

a,xyz

]Where category='';