A meta collection about Loops, Switches, Paths and Flow Variables in KNIME (and some ZIP files)
Start with KNIME's Flow Control Guide
https://docs.knime.com/latest/analytics_platform_flow_control_guide/
Understanding KNIME Loops: A Concise Overview
https://medium.com/p/5a828e801077
-------------- LOOPS ----------------------
[loop] in the first loop iteration - overwrite the Excel file
https://forum.knime.com/t/group-loop-not-working-with-sheets-renaming/61194/2?u=mlauber71
Special loop example involving data bases
https://forum.knime.com/t/joiner-node-in-loop/11343/5?u=mlauber71
[loop] Recursive Loop (use a very simple loop to make a forecast prediction. Also use temporary table to store information in a loop an read it back)
https://forum.knime.com/t/recursive-row-loop-for-sales-forecasting/12955/10?u=mlauber71
[loop] use a very simple loop to make a forecast prediction. Also use temporary table to store information in a loop an read it back
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_recursive_loop_storage_week_forecast?u=mlauber71
-------------- PATH ----------------------
[path] Create path variables in KNIME
https://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2?u=mlauber71
[path] extract paths stored in a node
https://forum.knime.com/t/add-read-sheet-protection-to-excel-file/63860/5?u=mlauber71
even more fun with URI, URL and File Paths - work with the new Path variable format to list and move/copy files - using the latest KNIME version 4.6
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_uri_url_path_even_more_fun_with~GHc1ULoqWE_kZFOB?u=mlauber71
[zip] A collection of methods to ZIP and UNZIP files with KNIME (and R)
https://hub.knime.com/-/spaces/-/~sl4rYEzjFPm7a99a/
[transfer] How to transfer a whole structure of workflows from one path to another
https://forum.knime.com/t/transfer-files-table-bug/67184/5?u=mlauber71
https://hub.knime.com/-/spaces/-/latest/~B8L3dwKse5ro3lw7/
[transfer] create your own backup system of KNIME workflows of KNIME workflow groups
https://forum.knime.com/t/copy-move-files-node/29412/15?u=mlauber71
https://hub.knime.com/-/spaces/-/latest/~_tjPYVJCbqMAqTSC/
-------------- SWITCH -----------------------
[switch] An example of combining SQL database, loop and case switch
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_switch_case_store_file_sql~k2DRahhctYmHk-zg
[switch] Check if column is present and use if-switch accordingly
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_if_switch?u=mlauber71
[switch] Use Java Snippet to check if Column is there, fill a FlowVariable and then activate if switch
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_java_if_column_exists_switch?u=mlauber71
[switch] Hive - how to handle missing tables in Hive? (or any database)
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_hive_missing_table_switch?u=mlauber71
[switch] Two ways to handle combination of Flow variables from Python and If switches
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_python_flow_variable_if_switch?u=mlauber71
use loop and the Wait node to execute a database query at fixed times
https://forum.knime.com/t/start-a-workflow-e-g-a-database-query-after-a-certain-time/30287/36?u=mlauber71
External resources
- Special loop example involving data bases
- Recursive Loop
- A collection of methods to ZIP and UNZIP files with KNIME (and R)
- Start with KNIME's Flow Control Guide
- use loop and the Wait node to execute a database query at fixed times
- [switch] Check if column is present and use if-switch accordingly
- [switch] Use Java Snippet to check if Column is there, fill a FlowVariable and then activate if switch
- [switch] Hive - how to handle missing tables in Hive? (or any database)
- [switch] Two ways to handle combination of Flow variables from Python and If switches
- [loop] use a very simple loop to make a forecast prediction. Also use temporary table to store information in a loop an read it back
- even more fun with URI, URL and File Paths - work with the new Path variable format to list and move/copy files - using the latest KNIME version 4.6
- Create path variables in KNIME
- [switch] An example of combining SQL database, loop and case switch
- [transfer] How to transfer a whole structure of workflows from one path to another
- [transfer] create your own backup system of KNIME workflows of KNIME workflow groups
- Understanding KNIME Loops: A Concise Overview
- [loop] in the first loop iteration - overwrite the Excel file
- [loop] Excel - Loop over Sheets and turn into individual Files - KNIME Forum (78171)
Used extensions & nodes
All required extensions are part of the default installation of KNIME Analytics Platform version 4.7.8
No known nodes available
Legal
By using or downloading the workflow, you agree to our terms and conditions.