Compare value from 2 sql result and use it

[PierrickB]

Hi,

I've tried to compare value from 2 sql result (SELECT), i would like to have all data that are not present in the second sql result.

Here the schema :

  

and this is the tmap :

 

I don't understand why it doesn't work.

In the final logRow i have 600024 rows , but it should 2 or 3.

Can you please help me ?

thanks.

[Anonymous · Accepted solution]

Hi,

you need to make a join with your 2 flows like this : 

Regards, 

Pierre

[PierrickB]

Hi,

thans for your response, it works. i've tried to join but not with this expression in the filter

Regards