Split the Data

[Anonymous]

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

[TRF]

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

[Anonymous]

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?

[TRF]

Use tFilterColumn or tMap to remove unwanted column(s)