From rows to columns


(Valeria Voronina) #1

Hi,
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
#3

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)