topic How to obtain unjoined rows in a tMap ? in Talend Studio

How to obtain unjoined rows in a tMap ?

iztoogood — Fri, 15 Nov 2024 22:06:43 GMT

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 — Sat, 11 Feb 2023 22:34:15 GMT

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

whith a filtre like :

!row4.col2.equals(row3.col2)

Anonymous — Sun, 12 Feb 2023 23:19:17 GMT

Glad to see you figured out a solution yourselves.

Regards

Shong