tfilterrow logic

Five Stars

tfilterrow logic

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.
Community Manager

Re: tfilterrow logic

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: tfilterrow logic

i am  reading data from text document and writing data into oracle table.
text document has data format as shown below.
ID|FName|LName|City|State|DOJ
110193|Thomas|Johnson|Columbus|ME|30-04-2015.
data is loaded into oracle table but when we run the job it is giving message in red color as:
For input string: "ID" 
Please find the image for reference.is this any error?if it is error i think data won't load into database.
Twelve Stars

Re: tfilterrow logic

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)
-----------
Community Manager

Re: tfilterrow logic

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: tfilterrow logic

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
Community Manager

Re: tfilterrow logic

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: tfilterrow logic

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?
Twelve Stars

Re: tfilterrow logic

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
-----------