Search code examples
pentaho

Split multiple fields to rows in pentaho 'split field to rows' activity


I have an array of phone numbers in my pentaho workflow. I am using split fields to rows activity and I am able to split that array to rows. Now I want to split multiple fields to row by using 'split field to rows' only once. I tried giving comma as a delimiter in the 'Fields to Split' in the input but getting error. How I can split multiple fields to rows by using 'split fields to rows' activity once ? [P.S. see attached image for referance]


Solution

  • The Split field to rows accept only one input field to split.

    You may put a series of Split field to rows, one for each field.

    Alternatively, you may concatenate your multiple fields in a single field before to split it.