Icon

09. Workflow Control - solution

Workflow Control - Solution
Activity I: Group Looping - Read the file: CurrentDetailData.table - Group over all the values in the Products column - For each group of data, write a new KNIME table to your KNIME Workspace. Give it an appropriate filename. Activity II: Reading Many Files - Use List files to find the file names of the files created in the previous exercise - Iterate over that list of files, and concatenate them into a single KNIME table Activity III: CASE Switch Extend the workflow below with a switch to select the kind of visualization. - Use a Single Selection Configuration to let a user choose the values "scatter" or "bar" - Use a CASE Switch Data (Start) to create either a scatter plot or a bar plot depending on the input. - Use the "...(index)" flow variable to define the active port.- Combine the two paths with a CASE Switch Data (End) Read CurrentDetailDataGenerate the nameof the file to writeCollect variableand end loopRead the entire tableWrite one file to diskDo one iterationper product valueList all filesin the directoryLoop overfile names(1 per iteration)Combine read fileinto single tableRead fileCombine pathesinto oneSelect baror scatter Table Reader Image To Table Image To Table Table To Image Scatter Plot Bar Chart Create File Name Variable Loop End Table Reader Table Writer Group Loop Start List Files Table Row ToVariable Loop Start Loop End Table Reader CASE SwitchData (Start) CASE SwitchData (End) Single SelectionConfiguration Activity I: Group Looping - Read the file: CurrentDetailData.table - Group over all the values in the Products column - For each group of data, write a new KNIME table to your KNIME Workspace. Give it an appropriate filename. Activity II: Reading Many Files - Use List files to find the file names of the files created in the previous exercise - Iterate over that list of files, and concatenate them into a single KNIME table Activity III: CASE Switch Extend the workflow below with a switch to select the kind of visualization. - Use a Single Selection Configuration to let a user choose the values "scatter" or "bar" - Use a CASE Switch Data (Start) to create either a scatter plot or a bar plot depending on the input. - Use the "...(index)" flow variable to define the active port.- Combine the two paths with a CASE Switch Data (End) Read CurrentDetailDataGenerate the nameof the file to writeCollect variableand end loopRead the entire tableWrite one file to diskDo one iterationper product valueList all filesin the directoryLoop overfile names(1 per iteration)Combine read fileinto single tableRead fileCombine pathesinto oneSelect baror scatter Table Reader Image To Table Image To Table Table To Image Scatter Plot Bar Chart Create File Name Variable Loop End Table Reader Table Writer Group Loop Start List Files Table Row ToVariable Loop Start Loop End Table Reader CASE SwitchData (Start) CASE SwitchData (End) Single SelectionConfiguration

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: knime
Created at: 2014-06-17
On NodePit since: 2019-08-19
Last update: 2020-03-23
Created with KNIME version: v4.0.0
Tags: loopreading many filesswitchalternative branchworkflow controleducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!