Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Filter IN / NOT IN

Hi, would be great to add IN / NOT IN support for filter component.

Better yet, please allow free-style filter expressions without being limited to a predefined list of comparison operators.

2 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Dobo,

Thanks for the suggestion. I have raised a ticket for your request EMD-4482.

As a workaround, you may use a SQL component in your workflow to write some SQL using the $T{} syntax.

For example you may use the following SQL in a “SQL” Transform Component to refer to an incoming component and write a filter expression.

Select * from $T{flights} where year NOT IN ( 1994, 1996, 1998, 2000 )

Hope that helps.


Dobo Radichkov —

Thanks, yep I know I can work around it with generic SQL, just thought it would be nice to allow for more complex where conditions in the Filter component itself.

Post Your Community Answer

To add an answer please login