Icon

Pivot Table Automation

import monthlypurchase order files
Excel Reader
Aggregate purchasevolumes(per category andgrand total)
Row Aggregator
group sum of amountcount of POsby category
GroupBy
spend percategory andmonth
Pivot
Add month name(DE)
Date&Time Part Extractor
write to../data/output/aggregated_volumes_category_month.xlsx
Excel Writer

Nodes

Extensions

Links