unmatched values from first column as result

[thimma_paul]

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

[avinashelite]

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)

[robert_mika · Accepted solution]

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);

[prajapatiamar38]

PFA

[robert_mika]

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)