topic Re: unmatched values from first column as result in QlikView

unmatched values from first column as result

thimma_paul — Thu, 21 May 2015 07:39:29 GMT

Requirement:

Col1 is in Table1

----

12345

2345

3456

4567

5678

Col 2 is in Table2

-------

12345

9876

1234

2345

4567

Result should be :

3456

5678

Unmatched values from Col1 as ResultColumn

Re: unmatched values from first column as result

avinashelite — Thu, 21 May 2015 07:49:23 GMT

try with not exist function like this:

T1:

Load

column1

12345

2345

3456

4567

5678

from table 1;

T2:

Load

col2

12345

9876

1234

2345

4567

from table 2 where not exist(column1, col2)

Re: unmatched values from first column as result

robert_mika — Thu, 21 May 2015 07:49:31 GMT

T1:
load * Inline [
Col1
12345
2345
3456
4567
5678
];

T2:
load * Inline [
Col2
12345
9876
1234
2345
4567
];

Load
Col1 as ResultColumn

Resident T1 where Not Exists (Col2, Col1);

Re: unmatched values from first column as result

prajapatiamar38 — Thu, 21 May 2015 08:03:56 GMT

PFA

Re: unmatched values from first column as result

robert_mika — Thu, 21 May 2015 10:37:13 GMT

You can not do that in front end

To get all 3 tables use this

Tab1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

Tab2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

t3:

load Col2 as col3

Resident Tab2;

right join

load Col1 as col3

Resident Tab1

where not Exists(Col2,Col1)