topic Re: Filter Rows by Substring in Talend Studio

Filter Rows by Substring

Anonymous — Wed, 01 Aug 2012 18:59:54 GMT

I want to filter out rows if "total" or "sub total" is found in the test from a particular column.
Since this is a substring I am looking for I wasn't sure what the best approach was.
Thanks,

Re: Filter Rows by Substring

alevy — Thu, 02 Aug 2012 02:03:18 GMT

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")

Re: Filter Rows by Substring

Anonymous — Thu, 02 Aug 2012 15:30:21 GMT

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")

Thanks Alevy. I stumbled across it (had to scroll in the panel to see it) and got it to works.
Thanks Again!