The image in the annex shows my workbench.

This is the result that can be seen in ‘Passed from Tester_2’:

NAME ; DBK

Organisation X1 ; 111

Organisation X2 ; 222

This is the result that can be seen in ‘SQLCreator_3’:

ID ; OWNER_ORG ; CLIENT_ORG ; MONITOR_ORG

1 ; 111 ; 111 ; 333

2 ; 222 ; 222 ; 222

3 ; 333 ; 444 ; 555

4 ; 333 ; 222 ; 333

5 ; 444 ; 555 ; 111

I would like to use a transformer that uses the results from ‘Passed from Tester_2’ to check if one of these DBK values is present in the organisation columns of result ‘SQLCreator_3’.

So I need the transformer to select ID 1, 2, 4 and 5. But not 3 as Organisation X1 and X2 is not present in one of the three organisation columns. 

Can anyone explain to me how I can do this?

Thanks in advance!