Transpose

Problem:

Suppose we have a table with spend & revenue statistics distributed by months that are marked in rows. We would like to transpose the table into a report with “Spend” and “Revenue” rows. The months would be indicated in separate columns.

Resolution:

We will be using the “Transpose” building block to switch their places and have a more understandable output report. To do so, we will be taking the following steps.

Step 1

Let’s open Conduit’s Workflows and add the “Pull Data” building block to the canvas and select our dataset.

Step 2

Now we add the “Transpose” building block to the canvas and we make sure that the first dimension is a string, not a number. Now, let’s view our output report. So, in the initial dataset the rows resemble the months, and in the new dataset the rows resemble the metrics.