Ask Your Question
1

Filter Data using Stream Selector for multiple values

asked 2019-02-06 11:05:05 -0500

srinath_222 gravatar image

updated 2019-02-06 11:05:27 -0500

Hi,

I am trying to filter the incoming data using Stream Selector for multiple values.

For example, I want to filter the data which has values of employee, department for column table_name. I am using Stream Selector with expression for single value:

${record:value("/table")=='employee'}

But I need to include two table names. Please suggest us how to use IN operator.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2019-02-06 11:13:44 -0500

metadaddy gravatar image

There is no IN operator in Expression Language, but you can use a regular expression for this:

${str:matches(record:value('/table'), 'employee|customer')}
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2019-02-06 11:05:05 -0500

Seen: 22 times

Last updated: Feb 06