Expression filter doesn't work

[jensej]

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 · Accepted solution]

Can you double check your expression?

!row1.conn.equals("normal")

[jensej]

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

[Anonymous]

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?​