Knime - Read a Sheet, All Sheets in a Workbook, and All Workbooks in a folder.
Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-v...
In this video review how to read an individual sheet, all the sheets within a workbook and all the workbook and all the sheets within a folder
This workflow reads the data converts a string into a date using the "String to Date&Time" Node then uses "Extract Date&Time Fields" Node to pull the month and finally uses the "GroupBy" Node to summarize the Revenue by month
For the two loops the "Table Row to Variable Loop" to convert the rows into Variables and then loop through them. The variables are passed to the Reader and used to Set the Sheet and File Name
Excel Reader:
https://www.knime.com/knime-introduct...
Group By:
https://www.knime.com/knime-introduct...
Flow Variables:
https://www.knime.com/knime-introduct...
Loops:
https://www.knime.com/knime-introduct...
