From rows to columns

(Valeria Voronina) #1

I need to move data from rows to columns.
Can I do this using steps, not manually?

Thanks, Lera

(Aleksandr Lisichkin) #2

Hi Valeria!
I Think that your solution is on SQL selection. Use PIVOT or UNPIVOT operators.

Columns to Rows

Hi Valeria,

You can do pivoting (rows to columns) with Group Aggregator step.
Here is example plan that takes sample file with 3 columns (year, product, sale amount) and generates report with following columns: (year, Tea sales, Cookies sales)

sales.txt (87 Bytes)
pivot_sample.plan (3.8 KB)