Excel Pivot Tables Made Me Quit (Until Now)

2 Просмотры

Спасибо! Поделитесь с друзьями!

Вам не понравилось видео. Спасибо за то что поделились своим мнением!

Издатель Oct 2, 2026

Every month the same pivot table: paste the new export, check the range, hit refresh - and then somebody wants it by quarter. So I stopped building it and started running it.

Twelve monthly purchase-order files, one folder, three KNIME nodes from easiest to hardest - Row Aggregator, GroupBy, Pivot - and an Excel Writer at the end, because your boss still wants an Excel file.

Workflow + sample data (KNIME Community Hub): https://hub.knime.com/kowisoft/spaces/Public/Pivot%20Tables%20made%20me%20quit%20Excel%20(Until%20Now)~b888iIuJcAWIwgcN/
New to KNIME? The basics: https://youtu.be/ogqwRmP5kLo?si=HQOyjahuopxvmWtb
What a table like this can turn into - a self-service dashboard: https://youtu.be/Ibvo7XTFNpw

CHAPTERS
0:00 Everybody in finance loves pivot tables
0:10 And then next month happens
0:34 A pivot table isn't a report
0:44 Today: 12 files, 2,389 orders, three nodes
1:06 Let's be fair to Excel
1:24 Insert, PivotTable - spend per category in 4 seconds
1:43 Dates into columns: one column per day
2:03 Rows, columns, values - remember these three boxes
2:16 The real job: a whole year in 12 files
2:42 Check the range, hit Refresh
2:53 "Why is this number different from last time?"
3:07 The real problem: the steps are invisible
3:17 The same question in KNIME
3:39 One Excel Reader, pointed at a whole folder
4:03 2,389 rows - and nobody pasted anything
4:15 Node 1 - Row Aggregator
4:28 One number: the grand total
4:41 Split by category, grand total on a second port
5:02 Plenty for a quick total - but it has limits
5:14 Node 2 - GroupBy
5:25 Group tab = rows, aggregation tab = values
5:41 Sum and count, side by side
5:55 Office supplies: 577 orders, barely €130k
6:06 Raw materials: 289 orders, €1.6M
6:27 Quick note: subscribe (the honest trade)
6:37 Node 3 - Pivot, the king of the three
6:52 First, turn the date into a month
7:06 The dialog, next to your Excel field list
7:33 If it says "mean", switch it to sum
7:43 Six categories down, 12 months across
7:57 Grand totals per category and per month
8:19 The "until now" from the title
8:30 Your boss wants an Excel file, not a workflow
8:43 Honest caveat: it's not a native pivot table
9:10 Next month: drop the file in, hit Execute
9:34 An Excel pivot you build. This you run.
9:44 Recap: three nodes, easiest to hardest
10:02 Excel was never the problem
10:18 Subscribe - and tell me which pivot you rebuild

Which pivot table do you rebuild every single month? Tell me in the comments.