topic Re: tFilterRow - Filter a field that contains values in the context in Talend Studio

tFilterRow - Filter a field that contains values in the context

Anonymous — Thu, 05 Mar 2015 17:01:09 GMT

Hello, I want to filter a string field "EVENT_NAME" to the values in my context. My context.event is A, B, C and D.
So in the tFilterRow Advanced mode, I want to code something like this input_row.EVENT_NAME.equals(context.event). I mean input.row.EVENT_NAME.equals("A","B","C","D")
Is there a way to do it? Could you provide me the syntax to get this filter works.
Thanks in advance!

Re: tFilterRow - Filter a field that contains values in the context

_AnonymousUser — Thu, 05 Mar 2015 22:30:08 GMT

Hello,
If I understand your problem correctly, your context variable context.event can only contain "A", "B", "C", and "D". In that case you can just use input_row.EVENT_NAME.equals(context.event) in your filter, and it should filter out all other values.
If you want to check if your field EVENT_NAME contains only one of the allowed values, you can use :
"ABCD".contains(input_row.EVENT_NAME) && input_row.EVENT_NAME.length() == 1
the second part ensures that your field is only one character, so that "AB" doesn't match for instance.

Re: tFilterRow - Filter a field that contains values in the context

Anonymous — Fri, 06 Mar 2015 17:13:24 GMT

Hi,
The input_row.EVENT_NAME.equals(context.event) is what I want to do to get all the rows which have "A", "B", "C" and "D". However I don't get any match. I get zero rows in my output. In my data has some "A", "B", so I should get some matched rows.
I don't know if I miss anything?
Thank you for your help!

Re: tFilterRow - Filter a field that contains values in the context

talendtester — Tue, 23 Apr 2019 22:32:48 GMT

Use tFilterRow combined conditions Or advanced condition:

input_row.columnName.contains("A")||

input_row.columnName.contains("B")||

input_row.columnName.contains("C")||

input_row.columnName.contains("D")||