Activity I: Write data from different cities to separate files using a loop

Start from the workflow from Activity II of 01_Flow Variable and Component - Exercise you completed earlier. Insert a Group Loop Start node before the Store with Highest Total Sale metanode. Iterate over different city names in the column City.
Create a path flow variable for the location and the name of the output Excel file. The filename is the name of the city, followed by the execution date&time.
- Make a flow variable connection between the Group Loop Start node to the Date&Time Configuration node.
- In the String Manipulation (Variable) node, use the flow variable City as the filename (hint: use the expression join($${SCity}$$,replaceChars($${SExecution_date}$$,":." ,"--" )) ).
- In the Create File/Folder Variables node, change the location to the temp folder under the data folder (hint: use a relative path from the workflow, with the path ../../data/temp )
Write the records from the store with the highest total sale in the city of the current iteration to an Excel file
- Propagate the output table from the Store with Highest Total Sale metanode to an Excel Writer node. It contains the records only from the city of the current iteration.
- Make a flow variable connection from the Create File/Folder Variables node to the Excel Writer node. Set the output file path with the path flow variable output-location.
Add a Variable Loop End node, with a flow variable connection from Excel Writer node. You can try a step-by-step execution by pressing the Step button when hovering over this node. Or you can run all iterations by simply executing the Variable Loop End node.

02_Workflow Control - Solution

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME Excel SupportTrusted extension

KNIME JavasnippetTrusted extension

KNIME Quick FormsTrusted extension

KNIME ViewsTrusted extension

Legal

KNIME Base nodes

KNIME Excel Support

KNIME Javasnippet

KNIME Quick Forms

KNIME Views