Icon

Challenge 06 - November

Authenticate and list the files from the HUB

Get the database from HUB and load the data into KNIME

Get the tracker from HUB and the references

Create the actual YTD data with the new month if it differs from the month in the tracker

Write out into the new Excel

Open the newly created file

Get the workflowpath automatically
Extract Context Properties
Absolute reference of the newExcel file
String Manipulation (Variable)
Halt the execution if themonth in the tracker is thesame as in the data
Breakpoint
Get the month name from the label
Download thedatabase to theworkflow folder
Transfer Files (Table)
Original Excellinks
String Manipulation
Convertthe pathto string
Path to String
Variable for thebreakpoint
Rule Engine Variable
Wildcard"*.xlsx" (justtracker file)
Row Filter
Load thedata into KNIME
DB Reader
Write outthe new Excelfile and fill with thedata
Excel Cell Updater
Get thetrackerinto variable
Table Row to Variable
Get the tracker
Excel Reader
Get just the relevant data
Row Filter
Get the total salesby product lines
GroupBy
Create the proper file references
Refresh the YTDwith the new numbers
Math Formula
Get the new monthbeside the YTD
Joiner
Put the labelinto the table
Rule Engine
Filter outthe Sum(SALES)column
Column Filter
Put the labels row in there
Constant Value Row Appender
Filter outthe product line
Column Filter
Connect tothe appropriatespace
Space Connector
Open the new Excel file
Java Snippet
Authenticateto KNIME Hub
KNIME Hub Authenticator
Get the months and the last day from the data
New location and label
Connect tothe database
SQLite Connector
List the filesfrom the space
List Files/Folders
Select theorder table
DB Table Selector

Nodes

Extensions

Links