topic Re: Compare value from 2 sql result and use it in Talend Studio

Compare value from 2 sql result and use it

PierrickB — Tue, 21 Jan 2020 10:28:16 GMT

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 — Tue, 21 Jan 2020 14:31:53 GMT

Hi,

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

Regards,

Pierre

PierrickB — Tue, 21 Jan 2020 14:50:32 GMT

Hi,

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

Regards