Monday, 14 January 2013

Split one column value to multiple columns using tExtractDelimitedFields Talend Open Studio

Split one column value to multiple columns using tExtractDelimitedFields Talend Open Studio

In the earlier post here, I have shown, How to split column values to multiple records using tNormalize component. In this post, I will show you, How to extract value of single column into multiple columns in Talend Open studio using tExtractDelimitedFields component.




 
Job Design:








Input File:

emp_no;emp_name;emp_skills
101;Avinash Gupta;java,C++,sql
102;Vikas Gupta;oracle,HTML,JSP,AJAX
103;Mayank Arora;Talend,Abinitio,OBIEE

Input in run console



Notice there are only three column in Input.

Output in Run console



In the output we have split values of skills column to multiple skill columns in output.

Component properties of tExtractDelimitedFields component 


You may also like to read..

2 comments:

  1. Good job vikram, may i know how to create duplicate rows of a file based of certain constraints.

    ReplyDelete
    Replies
    1. Thanks Sajish, I would be happy to answer you.

      Request you to provide more details for ur query. It would be helpful if you can explain with example.

      Delete