Saturday 19 January 2013

Talend tfilterColumn usage


Using tFilterColumn component in your job

tFilterColumn component is a very useful component - which can be used in your jobs just simply to restrict the number of columns passing from one component to another - you can achieve the same from tMap but tFiltercolumns make is more explicit that you are filtering th e columns from one flow to another.

In example below we are reading data from a delimited file and then removing/filtering some columns from row7 to row8 in example below

 

when we click on schema of tFilterColumns_1 transformation as below you can see clearly the difference in columns in input and output


5 comments:

  1. Hi Arpit,
    i used this component to delete columns. but, it does not change anything. It is other option do that?

    ReplyDelete
    Replies
    1. with delete i understand if your input has 10 columns you want to take forward only say 2 columns..delete 8 columns..you can also use tMap to reduce number of columns in the pipeline

      Delete
  2. excellent piece of information, I had come to know about your website,i have read some posts of yours by now, and let me tell you, your site gives the best and the most interesting information. Keep sharing more useful and interesting topics.
    Talend Tutorial

    ReplyDelete
  3. Wonderful blog!!! Thanks for sharing this great information with us...
    SEO Course in Chennai
    SEO Online Training
    SEO Course in Coimbatore

    ReplyDelete