Requirement

[kulasekhar]

Hi All,

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

Thanks,

Kula

[Anonymous · Accepted solution]

so you want to load other column in Table3 which will have only those values which are not matching with table2 ?

or want to have a column in table1 itself saying these values are not in table2 ?

Thanks

BKC

[#3]

use left join try this.

ex.

Table1:

load

12345

2345

3456

4567

5679

from

.....

Table2:

left join(Table1)

Load

12345

9876

1234

2345

4567

from

.....

[Gysbert_Wassenaar]

You can use the Exists() function. A simplified example:

T1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

T2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

T3:

LOAD Col1

RESIDENT T1

WHERE NOT EXISTS(Col2, Col1);

[Anonymous]

You can also have left join if you have other columns in tab2

and then filter the records which are not in tab2

see the example

[kulasekhar]

Thanks

[kulasekhar]

I have changed in script.

Now write the expression in result column to solve the requirement.

[kulasekhar]

Hi BKC

  I have changed in script.

  Now write the expression in result column to solve the requirement.

[Anonymous]

correct