i have a scenario where input table column is like this
Date Of Brith emp name
01-05-2002 03-09-2017 Manish
07-05-2001 05-02-2016 Lokesh
i want to split this and load every date in new row
Date Of Birth emp Name
Thanks In advanced
I assume you are able to have a schema with 3 fields for your input.
In such a case, have a look to tSplitRow, it's here for that.
thanks for reply..
can you please explain me how it works, and how can we use tsplitrow for this scenario.
I suppose your schema is like this:
DateOfBrith1 DateOfBirth2 EmpName
Base on this schema, you 1rst need to define the output schema for the tSplitRow component:
Then, define the mapping for the tSplitRow like this:
Here, row3 is the input flow for tSplitRow, and 2 output records are made for each imput record, 1 with 1rst birthdate + name, the other with 2nd birthdate + name.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables