How to Split the fields

[Naren1984]

Hi,

I have input having 5 fields and 2 outputs I want to split 3 selected fields to the first output and remaining to the another output, how can I acheive this in PENTAHO

For Eg.
input fields
CL_CODE
NM
SCM_CODE
SCM_NM
CODE

1st output
CL_CODE
SCM_NM

2nd output
NM
SCM_CODE
SCM_NM
CODE
CL_CODE



Regards
Naren

[sboden]

Copy the rows from the origin step to 2 steps (meaning 2 outgoing hops from the origin using "copy mode") and then using a Select Values Step in both streams to remove unwanted fields.

Regards,
Sven

[Naren1984]

Thank you

Your solution worked perfectly.


Regards
Naren