A meta collection about Loops, Switches, Paths and Flow Variables in KNIME (and some ZIP files)

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

• [loop] Excel - Loop over Sheets and turn into individual Files - KNIME Forum (78171)
• [loop] in the first loop iteration - overwrite the Excel file
• Understanding KNIME Loops: A Concise Overview
• [transfer] create your own backup system of KNIME workflows of KNIME workflow groups
• [transfer] How to transfer a whole structure of workflows from one path to another
• [switch] An example of combining SQL database, loop and case switch
• Create path variables in KNIME
• 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
• [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
• [switch] Two ways to handle combination of Flow variables from Python and If switches
• [switch] Hive - how to handle missing tables in Hive? (or any database)
• [switch] Use Java Snippet to check if Column is there, fill a FlowVariable and then activate if switch
• [switch] Check if column is present and use if-switch accordingly
• use loop and the Wait node to execute a database query at fixed times
• Start with KNIME's Flow Control Guide
• A collection of methods to ZIP and UNZIP files with KNIME (and R)
• Recursive Loop
• Special loop example involving data bases