Icon

02. Workflow Control

Workflow Control

"Workflow Control" exercise for advanced Life Science User Training - Handle and write groups of data to separate sheets in an Excel file - Read and concatenate many sheets using a loop - Activate a workflow branch based on a user selection



Step 1Use the CASE Switch Startnode and select as input porttype "Data". In theconfiguration dialog control thePortIndex by the Flow Variable"plot-type (index)" from theSingle Selection Configurationnode. Step 2Use the CASE SwitchEnd node to end theswitch case. Activity I: Group Looping - Read the file: CHEMBLID228_SERT_ligands.table - Group over all the AssayIDs with a group loop - Write each AssayID to a separate sheet in an Excel file Step 1Use the Table Reader node to load theChEMBLID228_SERT_ligands.table Step 2Use the Group Loop Startnode to group and iterate overeach assay_chmebl_id Step 3Use the Excel Writer node to write eachtAssayID data table to a separate sheet onExcel file. Make sure to select "append" if filealready exists. The sheet name should be theAssayID for the current iteration (Hint: Pass thecurrent AssayID as a sheet name in the FlowVariable tab) Step 4Use the Variable Loop End node to end theloop. Step 3Use the Excel Reader node andconnect the Flow Variable portfrom the Table Row to VariableLoop Start. Use the flow variablecreated by the Table Row toVariable Loop node to control thesetting sheet_name in the FlowVariable tab Activity II: Reading Many Sheets - Use Read Excel Sheet Names to list all sheet names in an Excel file - Iterate over that list of sheets with a Table Row to Variable Loop, and aggregate them into a single KNIME table Step 2Use the Table Row to VariableLoop Start node to iterate over allsheets in the list Step 1Use the Read Excel SheetNames node to get a list of allsheet in the file "data/temp/assays.xlsx". Step 4Use the Loop End node to endthe loop. Pay attention: thecombined data from all loops isavailable in the output port of thenode. Activity III: If Switch Extend the workflow below with a switch to select the kind of visualisation. - Use a Single Selection Configuration node to let a user choose the values "Parallel Coordinates Plot" or "Scatter Plot", use the flow variable "port index" as output port - Use a CASE Switch Start node to create either a parallel coordinate plot or a scatter plot depending on the input. - Use Column Rename node to rename the plot selection column in both branches "Selection" - Combine the two paths with a CASE Switch End node and use a Row Filter node to filter only the selected compounds List all sheet names from an Excel fileCHEMBLID228_SERT_ligands.table RDKit DescriptorCalculation ParallelCoordinates Plot Scatter Plot Single SelectionConfiguration Column Rename Column Rename Row Filter Read ExcelSheet Names Table Reader Step 1Use the CASE Switch Startnode and select as input porttype "Data". In theconfiguration dialog control thePortIndex by the Flow Variable"plot-type (index)" from theSingle Selection Configurationnode. Step 2Use the CASE SwitchEnd node to end theswitch case. Activity I: Group Looping - Read the file: CHEMBLID228_SERT_ligands.table - Group over all the AssayIDs with a group loop - Write each AssayID to a separate sheet in an Excel file Step 1Use the Table Reader node to load theChEMBLID228_SERT_ligands.table Step 2Use the Group Loop Startnode to group and iterate overeach assay_chmebl_id Step 3Use the Excel Writer node to write eachtAssayID data table to a separate sheet onExcel file. Make sure to select "append" if filealready exists. The sheet name should be theAssayID for the current iteration (Hint: Pass thecurrent AssayID as a sheet name in the FlowVariable tab) Step 4Use the Variable Loop End node to end theloop. Step 3Use the Excel Reader node andconnect the Flow Variable portfrom the Table Row to VariableLoop Start. Use the flow variablecreated by the Table Row toVariable Loop node to control thesetting sheet_name in the FlowVariable tab Activity II: Reading Many Sheets - Use Read Excel Sheet Names to list all sheet names in an Excel file - Iterate over that list of sheets with a Table Row to Variable Loop, and aggregate them into a single KNIME table Step 2Use the Table Row to VariableLoop Start node to iterate over allsheets in the list Step 1Use the Read Excel SheetNames node to get a list of allsheet in the file "data/temp/assays.xlsx". Step 4Use the Loop End node to endthe loop. Pay attention: thecombined data from all loops isavailable in the output port of thenode. Activity III: If Switch Extend the workflow below with a switch to select the kind of visualisation. - Use a Single Selection Configuration node to let a user choose the values "Parallel Coordinates Plot" or "Scatter Plot", use the flow variable "port index" as output port - Use a CASE Switch Start node to create either a parallel coordinate plot or a scatter plot depending on the input. - Use Column Rename node to rename the plot selection column in both branches "Selection" - Combine the two paths with a CASE Switch End node and use a Row Filter node to filter only the selected compounds List all sheet names from an Excel fileCHEMBLID228_SERT_ligands.table RDKit DescriptorCalculation ParallelCoordinates Plot Scatter Plot Single SelectionConfiguration Column Rename Column Rename Row Filter Read ExcelSheet Names Table Reader

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: janinamothes
Created at: 2020-07-27
On NodePit since: 2024-06-15
Last update: 2024-11-04
Created with KNIME version: v4.6.1
Tags: loopreading many filesswitchalternative branchworkflow controleducationlife science

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

Try NodePit Runner!