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.


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)