How to obtain unjoined rows in a tMap ?

[iztoogood]

Hi,

i have 2 csv as tMap input :

main one is :

.----+----.

|tLogRow_1|

|=---+---=|

|col1|col2|

|=---+---=|

|1  |A  |

|2  |B  |

|3  |C  |

'----+----'

lookup is :

.----+----.

|tLogRow_2|

|=---+---=|

|col1|col2|

|=---+---=|

|1  |A  |

|2  |X  |

'----+----'

The value i'm trying to outputing is

.----+----.

|tLogRow_3|

|=---+---=|

|col1|col2|

|=---+---=|

|2  |X  |

'----+----'

i mean ...

row in lookup input that have a col2 different than the value found in main input col2

do you have an advice to manage to do it ?

[iztoogood · Accepted solution]

i managed to do something that look like what i wanted ...

whith a filtre like :

!row4.col2.equals(row3.col2)

[Anonymous]

Glad to see you figured out a solution yourselves.

Regards

Shong