topic Re: Expression filter doesn't work in Talend Studio

Expression filter doesn't work

jensej — Wed, 16 Nov 2022 07:52:27 GMT

Hi guys!

In this subjob I want to to split values from my query into two separate files depending on one column "conn".

If conn = 'normal' then write in Servers file and if conn = 'tunnel' then in the Onprem.

File Servers should have 218 rows and Onprem 34 rows. Somehow the Servers file also get filled with the rows that belongs to Onprem file...

There is nothing wrong with my query and if I run it in the database I get the result I expect.

Anonymous — Wed, 16 Nov 2022 07:58:45 GMT

Can you double check your expression?

!row1.conn.equals("normal")

jensej — Wed, 16 Nov 2022 08:03:47 GMT

Thanks, just found the problem myself. The ! was the problem

Anonymous — Wed, 16 Nov 2022 08:13:30 GMT

Regarding to your snapshot, seems there is something wrong in the expression filter for output 'servers' row

it should be :

row1.conn.equals("normal")

instead of

!row1.conn.equals("normal")

please try it to see if it fix your issue?