Transforming data


#1

Hello again,
I have two data sets, which are structured differently. I am trying to bring the data together in a single column to calculate my revenue.

Is there a way to Transpose (rotate) the data in a Pipeline, from horizontal to vertical? In Excel when you copy and then paste, you can use the Transpose function.

Using the following as an example, I would like to make 2016-09-01 the measure (column header) and have the numbers down the page: with company in column one:

  • One column wide
  • Seven rows deep


#2

Damon,
I think you are looking for the Unpivot step in the data pipeline. It will do exactly what you are asking for.