topic Re: how can split Date and insert as a new row in Talend Studio

how can split Date and insert as a new row

Anonymous — Mon, 15 Oct 2018 15:32:41 GMT

Hello everyone,

i have a scenario where input table column is like this

Input:-

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

Output:-

Date Of Birth emp Name

01-05-2002 Manish
03-09-2017 Manish
07-05-2001 Lokesh
05-02-2016 Lokesh

Thanks In advanced

Regards,

Manish

Re: how can split Date and insert as a new row

TRF — Mon, 15 Oct 2018 15:39:35 GMT

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.

Re: how can split Date and insert as a new row

Anonymous — Mon, 15 Oct 2018 15:51:05 GMT

hello sir,

thanks for reply..

can you please explain me how it works, and how can we use tsplitrow for this scenario.

Re: how can split Date and insert as a new row

TRF — Mon, 15 Oct 2018 16:02:38 GMT

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:

DateOfBrith
EmpName

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.