Introduction

Sometimes it is necessary to split a single record into multiple records, for example if a list of values are provided in a single attribute for one record.

Scenario

A list of values exist in an attribute, and we want to create a record for each item in the list. For example, the list may have come from a web service, and the identifiers need to be in separate records for further processing.

The scenario we will cover in this solution will be: a stream with one record - a comma separated list of 10 values and this will be processed such that it results in 10 records, each with a different one of the 10 values.

Solution

Solution:

• Create an output multiplier expression to parse the comma separated values into a list of 10 values
• Reference the values in that list with the _type internal variable.