Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have bad data in the First Name column that contains numbers, random series of numbers. How can I use tfilterrow to exclude these rows from mapping and loading? Thanks!
Hi Shong.
I tried this but am getting this error input_row cannot be resolved to a variable. See screen shot for what I did in tfilterrow.
Check the 'Use advanced mode' box and write the Java expression.
I actually tried that first and got this error:
This is what it looks like in the tfilterrow:
Strange I re-typed in 'StringHandling' and it worked and ran without erroring out.
Actually Shong... The filter is also removing some legitimate records because there are spaces after the first name values. Is there a way in this filter to use StringHandling.BTRIM(FRST_NAME) first to clean up the values or do i have to add another component before tfilterrow to do this first?