Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
i managed to do something that look like what i wanted ...
whith a filtre like :
!row4.col2.equals(row3.col2)
i managed to do something that look like what i wanted ...
whith a filtre like :
!row4.col2.equals(row3.col2)
Glad to see you figured out a solution yourselves.
Regards
Shong