Convert comma separated values into different rows
I’m trying to convert the comma separated values in a single row to a different number of rows.
Can anyone suggest me how should I approach?
I wanted to provide a solution that used the expression language in case others are interested.
Strings have a
split()
method that will split the string and return an array. From there, you can use themap()
method to create key/value pairs, like so:$Roles.split(',').map((elem, index) => ["Role" + (index + 1), elem])
(The argument to
map()
is a callback function that will be called with each element in the array and its index. The function then creates an array with the first element being the property name “RoleN” and the second being the element itself.)Once you have key/value pairs, you can feed it into the
extend()
method on objects to produce an object with the given pairs:$.extend($Roles.split(',').map((elem, index) => ["Role" + (index + 1), elem]))
Here’s an example pipeline:
SplitRoles_2019_01_24.slp (6.7 KB)