topic Re: tfilterrow logic in Talend Studio

tfilterrow logic

Anonymous — Wed, 26 Oct 2016 08:25:58 GMT

1)in oracle i can write query as select * from emp_data_test t where 1=1; which will return all rows.is it possible to implement same functionality in tfitlerrow if yes please explain.
2)in oracle i can write query select * from emp_data_test t where t.fname=t.lname ; in this we can check onecolumn value with another column.is same logic can be implemented in tfitlerrow .if yes please explain.

Re: tfilterrow logic

Anonymous — Wed, 26 Oct 2016 10:04:08 GMT

Hi
1) tFilterRow is used to filter the incoming rows, you don't need a tFilterRow if you want to pass all rows to the next component.
2) Yes, you can check the 'Use advanced model' and write the filter expression like this:
input_row.fname.equals(input_row.lname)
Regards
Shong

Re: tfilterrow logic

Anonymous — Wed, 26 Oct 2016 10:35:13 GMT

Re: tfilterrow logic

vapukov — Wed, 26 Oct 2016 11:02:29 GMT

As I remember it mean - You try to insert in INT column value "ID"
check on Your Input component - first row is header
or cut first row from file by any method (for example in tMap)

Re: tfilterrow logic

Anonymous — Wed, 26 Oct 2016 11:14:04 GMT

Hi
The first line is header in your file, so you should set the header filed to 1 on tFileInputDelimited to skip this line.
Regards
Shong

Re: tfilterrow logic

Anonymous — Thu, 27 Oct 2016 10:32:57 GMT

in "use advanced model" of tfilterrow
1)how to filter data which columns are having null values
2) how to filter data which columns are not having null values
3) how to filter data for City not equal to 'Banglore'
4)how to filter data for id column whose id greater than 1000
is all above conditions logic is possible in advanced model of tfilterrow

Re: tfilterrow logic

Anonymous — Fri, 28 Oct 2016 02:17:15 GMT

Yes, you can combine multiple conditions with logical operators && (and), ||(or), for example:
condition1&&condition2

1) input_row.colName==null
2) input_row.colName!=null
3) !input_row.City.equals("Banglore")
4) input_row.id>1000

Re: tfilterrow logic

Anonymous — Sun, 30 Oct 2016 11:45:22 GMT

1)how many inputs are connected to tUnite component.is there any limit on i/p s to tunite?
2)What is the maximum number of components we can use in a given job ?
3)what is the maximum number of columns while creating schema?

Re: tfilterrow logic

vapukov — Sun, 30 Oct 2016 12:19:00 GMT

1)how many inputs are connected to tUnite component.is there any limit on i/p s to tunite?
2)What is the maximum number of components we can use in a given job ?
3)what is the maximum number of columns while creating schema?

answer for all of question - many (if need exactly think Shong will answer)
but generally - try use single Job as small as possible,
split it for subjobs, use RunJob if need make multi step, use Loops
it make work and faster and more easy for debug
Examples - on attached picture, we are merge hundreds of files with tUnite, but as You ca see - only 2 at time (I ca not guess size of picture if connect all of them 🙂 )
This is not recite for 200% of cases, just ideas for use