Introduction

This step allows you to split a row containing a delimited field into multiple new rows, one per split value.
The original row is not delivered to following steps. The original field is left in each new row to assist in debugging or error handling.  It can be removed via a Select Values step if needed.

The original field must be a string field.
A new field name must be specified.
If the value type/format of the new row is not specified, the new field will use the same type/format as the original field.

Author

This plugin was written by Daniel Einspanjer and was contributed on the PDI forum.

Installation

Unzip file SplitFieldToRows.zip to the plugins/steps directory of your Pentaho Data Integration distribution.  Version 2.3 through 2.5 is required for this plugin to work.

Source code

The source code for the plugin is available under an LGPL license over here in subversion.

Debug or build

Extract the contents of src.zip into a directory sibling to your "Kettle trunk" project (note, if your Kettle project isn't named "Kettle tr
unk", you will have to manually fix the build.xml and .project files. "Kettle trunk" is the name specified in kettle's .project file checked
 out from SVN).

Ant builds to distrib and deploys to the kettle plugins folder.

Eclipse project has a run configuration for Spoon defined and will also copy the plugin.xml and icon resources to the Kettle plugins folder.

Example

Download this example to see this plugin in action.

Screen shot