Split to columns

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

Resolution:

In this case we will be using the “Split to columns” building block in order to separate the columns. To do so just follow these 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

To process the dataset further we will need to use the “Split to Columns” building block. Let’s add it to the canvas. Now we need to indicate which column we are going to transform and what is the delimiter. In our case it is a comma.

Step 3

In the building block we need to indicate that the first element will be put to column N1, and the second element will be put to column N2. Let’s view our report now. Now we see that the columns are created. Item 1 and Item 2 are listed in the newly created columns.