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]
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.