[resolved] tFilterRow Advance Mode Error

jdlo_25 — Fri, 22 Apr 2016 04:48:12 GMT

Hi Guys,
Good Day!
I'm trying to work on a project where I need to filter a row with some string on a specific column like "Not". I used the advance mode of the tfilterrow and define the condition:
input_row.ColumnName.indexOf("Not") == -1 I also tried !input_row.ColumnName.contains("Not")
and it seems to filter out the row with the string on the column on it but it also filter out some rows that has no "Not" on that column.
I figure it out using the rejects output of the tfilterRow because I include the error message and some rows is an error because of the advance condition that I set up.
Is there any more accurate way to filter it out?
Thanks In Advance
Regards
John

Re: [resolved] tFilterRow Advance Mode Error

Anonymous — Fri, 22 Apr 2016 06:44:22 GMT

Hi
The expression is used to filter all the rows that don't contains "Not", what are your expected result? An example will be helpful for us to understand the request.

Regards
Shong

topic Re: [resolved] tFilterRow Advance Mode Error in Talend Studio

[resolved] tFilterRow Advance Mode Error

Re: [resolved] tFilterRow Advance Mode Error