Split to rows

Problem:

Suppose we have the raw data sheet where the columns contain information in list format. The elements of that list are separated by comma. We would like to turn them into separate rows.

Resolution:

In this case we will be using the “Split to rows” building block in order to separate the rows. To do so just follow these two simple steps.

Step 1

Let’s open Conduit’s Workflows and add the “Pull Data” building block to the canvas and select our dataset. Make sure that the dimension type for the values that are separated by comma is string.

Step 2

Now we add the “Create Report/Aggregate” building block and subsequently the “Split to rows” building block. Here we select which column we are going to transform and what is the delimiter. In our case it is a comma. Now we can view our ready output report.