Simple pivoting

The next business case results needed are visualizations for the top 20 vendors by total amounts and invoice counts (for the whole period, not by month) and a table of all the vendors with amounts and invoice counts per month. You also need a table of each month with the amounts and invoice counts by category. The tables will be exported in the next stage of the process to be archived.

For this exercise, you'll be grouping, pivoting, and aggregating the relevant data.

If you lost any progress, browse your Local space, click on the case Study - financial analysis in KNIME folder, and load the 3_3_groupby workflow from the Exercises folder.