topic Split the Data in Talend Studio

Split the Data

Anonymous — Sat, 24 Aug 2019 17:40:44 GMT

How to split the data of source table column-wise with respect to primary key

Re: Split the Data

TRF — Sat, 24 Aug 2019 18:01:06 GMT

Can you give an example?
Maybe tSplitRow could be the answer.

Re: Split the Data

Anonymous — Sat, 24 Aug 2019 18:17:49 GMT

How to split the data of source table column-wise with respect to primary key. See the source and target tables below.
source table: ID is the key column, Name and Phone No are non-key columns

ID Name Phone No
10 AAA 123
20 BBB 234
30 CCC 434
40 DDD 343
50 EEE 442

Target Table 1

ID Name
10 AAA
20 BBB
30 CCC
40 DDD
50 EEE

This is the exact question?

Re: Split the Data

TRF — Sat, 24 Aug 2019 19:31:32 GMT

Use tFilterColumn or tMap to remove unwanted column(s)