Icon

20230620 Pikairos Copy One Row In Multiple Rows With Delimiter

This workflow shows how to convert a string of separated items by comma into a list of items and from it, how to generate from the list a new row per item.

For instance, the following table:

Topic Related Number
Label 36,23
Material 35
Engine 36,12,53

is converted into the next one:

Topic Related Number
Label 36
Label 23
Material 35
Engine 36
Engine 12
Engine 53

Your DataSplit and Aggregateas a List of ItemsUngroup theList of Items intoDifferent RowsTable Creator Cell Splitter Ungroup Your DataSplit and Aggregateas a List of ItemsUngroup theList of Items intoDifferent RowsTable Creator Cell Splitter Ungroup

Nodes

Extensions

Links