This node forwards the input from the first port if the execution was successful. If execution on the top branch failed (and a matching try node was connected before the failing node!) then the input from the second port will be forwarded and the second variable outport will contain information about the observed error.
Options
Popular Successors
- Variable Loop End7 %
- Merge Variables4 %
- Send Email3 %
- Timer Info3 %
- Excel Reader2 %
- Rule Engine Variable1 %
CASE Switch Variable (End)1 %XML Reader1 %Flow Variable IF Switch1 %Variable to Table Column1 %CSV Reader1 %Table Reader1 %- IF Switch1 %
- Python Script (legacy)1 %
- Wait...< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- Concatenate< 1 %
- Configurable End IF/CASE< 1 %
- Variable to Table Column< 1 %
Database SQL Executor< 1 %- Variable Condition Loop End< 1 %
- Constant Value Column< 1 %
- Write To Excel Template (deprecated)< 1 %
- Catch Errors (Generic Ports)< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
- Table Row to Variable< 1 %
Database Drop Table< 1 %- Java Edit Variable< 1 %
- Loop End< 1 %
Loop End< 1 %Recursive Loop End< 1 %- Column Filter< 1 %
Row Filter (deprecated)< 1 %- String Manipulation (Variable)< 1 %
- Rule-based Row Filter< 1 %
CASE Switch Data (Start)< 1 %- Variable Expressions< 1 %
Excel Reader (XLS)< 1 %- List Files/Folders< 1 %
Flow Variable End IF< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Unzip Files (legacy)< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
CSV Writer< 1 %- CSV Reader< 1 %
- Table Reader< 1 %
- Table Writer< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
Variable Condition Loop End< 1 %- Recursive Loop End< 1 %
Variable Loop End< 1 %- Table Manipulator< 1 %
- String Manipulation< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- DB Connection Closer< 1 %
- DB Query Reader< 1 %
- Column Expressions< 1 %
- Math Formula (Variable)< 1 %
- Excel Writer< 1 %
- Java Edit Variable (simple)< 1 %
- Delete Files/Folders< 1 %
- String to Path (Variable)< 1 %
- Transfer Files< 1 %
- Double Widget< 1 %
- Text Output Widget (legacy)< 1 %
- Workflow Service Output< 1 %
- Start WebDriver< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %Variable to Table Row< 1 %Database Connector< 1 %List Files< 1 %Regression Predictor< 1 %Column Appender< 1 %Column Rename< 1 %- Math Formula< 1 %
Transfer Files< 1 %- Date&Time Input (legacy)< 1 %
- Python Source (legacy)< 1 %
Execute JavaScript< 1 %- FeatureFinderMetabo< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Variable to Table Row< 1 %- File Reader< 1 %
- PySpark Script (1 to 1)< 1 %
- MySQL Connector< 1 %
- DB Table Selector< 1 %
- H2O to Table< 1 %
- Google Sheets Updater< 1 %
- Parameter Optimization Loop End< 1 %
- Python Edit Variable (legacy)< 1 %
- Variable Timed Loop End< 1 %
- Download (legacy)< 1 %
Table Row To Variable Loop Start< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Database Update< 1 %Line Reader< 1 %Table Writer< 1 %CASE Switch Variable (Start)< 1 %Merge Variables< 1 %Hive Connector< 1 %- Amazon Redshift Connector< 1 %
- DB Insert< 1 %
- DB SQL Executor< 1 %
- Empty Table Creator< 1 %
Excel Writer (XLS)< 1 %- Send to Tableau Server< 1 %
- Create File/Folder Variables< 1 %
- Date&Time Configuration< 1 %
- Text Output (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Column Selection Widget< 1 %
- Single Selection Widget< 1 %
- Container Output (JSON)< 1 %
- R to R< 1 %
- XPath< 1 %
- Message Slack channel< 1 %
- Run Garbage Collector< 1 %
- String to Table< 1 %
- ARIMA Learner< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- SSH Connection (legacy)< 1 %
- Upload (legacy)< 1 %
- URI to String< 1 %
- URL to File Path (Variable)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %- Variable to Credentials< 1 %
Database Query< 1 %Extract Context Properties< 1 %- Extract System Properties< 1 %
- CSV Writer< 1 %
File Reader< 1 %- Feature Selection Loop End< 1 %
Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Loop End (Column Append)< 1 %- Group Loop Start< 1 %
- Decision Tree Predictor< 1 %
- Add Empty Rows< 1 %
- Cell Splitter< 1 %
- Column Merger< 1 %
- Create Table Structure< 1 %
- Cross Joiner< 1 %
- GroupBy< 1 %
Joiner< 1 %- Value Counter< 1 %
- Data Generator< 1 %
- SDF Reader< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Connector< 1 %
- DB Writer< 1 %
Read XLS Sheet Names< 1 %Excel Reader (XLS)< 1 %- SSH Connector< 1 %
- Java IF (Table)< 1 %
- Decompress Files< 1 %
- Google Sheets Reader< 1 %
- Local File Browser Configuration< 1 %
- File Upload (legacy)< 1 %
- JSON Path< 1 %
JSON Reader< 1 %- JSON to Table< 1 %
Python Edit Variable< 1 %- GET Request< 1 %
- Time Generator (legacy)< 1 %
- XML Reader< 1 %
- Find Elements< 1 %
Extract Outer/InnerHTML< 1 %- Wait< 1 %
Views
- This node has no views
Workflows
00_xplan sf dbconv-insert via xport-AccountKNIME Hub
01 Data validation & Statistics Process ControlKNIME Hub- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- Show all 275 workflows
Links
- SQL Validation?by AnotherFraudUser on 2021-05-26forum.knime.com/p/124772
- SQL Validation?by AnotherFraudUser on 2021-05-31forum.knime.com/p/125164
- If no 1 fails, start no 2by AnotherFraudUser on 2022-10-09forum.knime.com/p/171770
- SQL SyntaxError Exceptionby AnotherFraudUser on 2020-08-12forum.knime.com/p/99744
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.