Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is null issue

hi all i have a script below:

table 1:

id             value

a                10

b               15

c                   20

table 2:

id          category

a               xyz

b              

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

3 Replies
Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand
Not applicable
Author

//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

b

];

RIGHT JOIN (table1)

LOAD *

RESIDENT table2

WHERE category='';

DROP TABLE table2;

er_mohit
Master II
Master II

Try this

Table1:

LOAD * INLINE [

    id, value

    a, 10

    b, 15

    c, 20

   

];

Inner Join

Table_2:

LOAD * INLINE [

id,category

a,xyz

b

]Where category='';