Allows running an external program on the data. It will write out
the incoming datatable into a temporary file which can be used as an input to
an external tool. After the tool finishes the node will read in an output
file the tool has (hopefully) created.
NOTE: Running an external executable takes the control out of our hands.
There will be no progress, no failure message, exceptions will not be caught,
it may even cause the entire KNIME platform to fail and you lose any unsaved
data, etc. Especially, if a shell script (or .bat file) creates sub processes (by
calling other programs), these sub processes will continue living even if
the node gets canceled. Furthermore, their output will not be fetched,
causing them (possibly) to block (not finishing their job) and to exist
until you kill them off manually.
Highlighting will not work across this node.
Colors are lost (the Color Manager node must be
inserted in the flow to re-generate colors).
The output of the external tool is caught and can be seen
in the node's views (the last 500 lines only, full output
is logged to KNIME's log file - if the log level is set to DEBUG, which is the
default).
Options
Popular Predecessors
- CSV Writer4 %
- Excel Writer3 %
Excel Writer (XLS)3 %Joiner3 %List Files2 %Table Row to Variable2 %Variable to Table Row2 %- Table Creator2 %
- Empty Table Creator2 %
Column Rename1 %Excel Sheet Appender (XLS)1 %- String Manipulation (Variable)1 %
Excel Reader (XLS)1 %- Table Column to Variable1 %
- Unzip Files (legacy)1 %
- Column Resorter1 %
Row Splitter (deprecated)1 %- JSON to Table1 %
Variable Loop End< 1 %Row Filter (deprecated)< 1 %- SDF Writer< 1 %
- Table Writer< 1 %
Table Column to Variable< 1 %Merge Variables< 1 %- Python Script (legacy)< 1 %
- Try (Data Ports)< 1 %
- Math Formula< 1 %
- Joiner< 1 %
- Variable Creator< 1 %
- Extract System Properties< 1 %
Table Reader< 1 %String To Number< 1 %- Missing Value< 1 %
- SDF Reader< 1 %
- Generic Web Service Client< 1 %
Variable to Table Row< 1 %- Write Variables< 1 %
- RowID< 1 %
- Excel Reader< 1 %
- Extract Variables (Data)< 1 %
- Group Loop Start< 1 %
XLS Reader< 1 %- Create Date&Time Range< 1 %
Table Column to Variable< 1 %- Timer Info< 1 %
- CASE Switch Start< 1 %
- Port to URI< 1 %
Database Writer< 1 %- Chunk Loop Start< 1 %
- Column Splitter< 1 %
- External SSH Tool< 1 %
- String Input (legacy)< 1 %
- JSON Transformer< 1 %
- CSV Reader< 1 %
- File Reader< 1 %
- DB Update< 1 %
- Math Formula (Variable)< 1 %
- Wait...< 1 %
CSV Reader< 1 %CSV Writer< 1 %File Reader< 1 %- Java Snippet< 1 %
- Concatenate< 1 %
- Column Combiner< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- Sorter< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Cache< 1 %
- Data Generator< 1 %
- External Tool< 1 %
Excel Reader (XLS)< 1 %Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- R Snippet< 1 %
- Copy/Move Files (legacy)< 1 %
Counting Loop Start< 1 %- Number to String< 1 %
- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- Table Row to Variable Loop Start< 1 %
- Duplicate Row Filter< 1 %
- Merge Variables< 1 %
- List Files/Folders< 1 %
- Create Temp Folder< 1 %
- Local File Browser Configuration< 1 %
- Container Input (Table)< 1 %
- Table Manipulator< 1 %
- Table Reader< 1 %
- Date&Time-based Row Filter< 1 %
- Inject Variables (Data)< 1 %
- Java Edit Variable< 1 %
- Column Rename (Regex)< 1 %
- Reference Row Filter< 1 %
- Ungroup< 1 %
- Empty Table Switch< 1 %
- Java Edit Variable (simple)< 1 %
- MultiLayerPerceptron Predictor< 1 %
Excel Reader (XLS)< 1 %- Java Snippet (simple)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to Date&Time< 1 %
- String to Path (Variable)< 1 %
- Git Push< 1 %
Loop End< 1 %Concatenate (Optional in)< 1 %- Constant Value Column< 1 %
- String Replacer< 1 %
- IF Switch< 1 %
- Create Temp Dir (legacy)< 1 %
- External Tool (Labs)< 1 %
- List Box Input (legacy)< 1 %
JSON Reader< 1 %XML Reader< 1 %- List Remote Files (legacy)< 1 %
- Create File Name (legacy)< 1 %
- Pivot< 1 %
CASE Switch Data (Start)< 1 %Extract Date&Time Fields< 1 %- MolConverter< 1 %
- Time Series Generator< 1 %
- Delete Files/Folders (Table)< 1 %
- RDKit Canon SMILES< 1 %
- Matlab Snippet< 1 %
Binary Objects to Files< 1 %- Files to Binary Objects< 1 %
Variable to Table Column< 1 %- Read Images< 1 %
Database Connection Table Reader< 1 %Column Appender< 1 %- One to Many< 1 %
- Create Table Structure< 1 %
- Partitioning< 1 %
- String Splitter (Regex)< 1 %
String Replace (Dictionary)< 1 %- Table Transposer< 1 %
- Parallel Chunk Start< 1 %
- OpenBabel< 1 %
- GET Request< 1 %
- Time Generator (legacy)< 1 %
- Sum Formula< 1 %
- Charge< 1 %
- Download (legacy)< 1 %
- Breakpoint< 1 %
Number To String< 1 %- End IF< 1 %
- Interactive Table (legacy)< 1 %
- DB Query Reader< 1 %
- Distance Matrix Calculate< 1 %
- File Chooser (legacy)< 1 %
- RDKit Add Conformers< 1 %
- Molecule Type Cast< 1 %
- Path to String (Variable)< 1 %
- String to Path< 1 %
Transfer Files< 1 %IF Switch (Flow Variable Value)< 1 %- Save File Locally< 1 %
- Delete Files (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- Extract URI Info< 1 %
- String to URI< 1 %
Database Delete< 1 %Database Reader< 1 %- Column List Loop Start< 1 %
- X-Partitioner< 1 %
Regression Predictor< 1 %Gradient Boosted Trees Predictor< 1 %- Send Email< 1 %
- Color Manager< 1 %
- One Rule Inserter< 1 %
- Java IF (Table)< 1 %
- Document Grabber< 1 %
- PDF Parser< 1 %
Python Script (1⇒1)< 1 %Python Source< 1 %- R Source (Table)< 1 %
- R to Table< 1 %
- RDKit Descriptor Calculation< 1 %
- FileToTable< 1 %
IF Switch (Flow Variable Value)< 1 %- Load Text Files< 1 %
- Benchmark Start< 1 %
- PNGs to Binary Objects< 1 %
- Strings to Binary Objects< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database SQL Executor< 1 %Parameterized Database Query< 1 %Extract Context Properties< 1 %Line Reader< 1 %Variable Condition Loop End< 1 %Recursive Loop Start< 1 %- MDS< 1 %
PCA< 1 %- Cell Splitter< 1 %
- Cross Joiner< 1 %
- Normalizer< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Top k Row Filter< 1 %
- Value Counter< 1 %
- Numeric Outliers< 1 %
Table to PDF< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Writer (XLS)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Tika Parser< 1 %
Strings To Document< 1 %- Column Filter (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
Container Input (Variable)< 1 %- Container Output (Table)< 1 %
JSON Writer< 1 %- Python Edit Variable (legacy)< 1 %
- POST Request< 1 %
- Git Pull< 1 %
- Test Data Generator< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Web Log Reader< 1 %
- String to XML< 1 %
- StringCell To File< 1 %
- RDKit Add Hs< 1 %
- RDKit To Molecule< 1 %
- Google Address Geocoder< 1 %
Generic Loop Start< 1 %- Column Auto Type Cast< 1 %
CASE Switch Variable (Start)< 1 %- DB Writer< 1 %
- Variable Expressions< 1 %
- Table to HTML (legacy)< 1 %
Excel Sheet Appender (XLS)< 1 %- Create Folder< 1 %
- Path to URI< 1 %
- CDK to Molecule< 1 %
Views
- Tool Output
- The text sent to standard out during the execution of the external tool.
(If it appears in gray, it's the output of a previously failing run
which is preserved for your trouble shooting.)
NOTE: Keeping the view open may slow down the process significantly, if it produces a lot of output in a short amount of time. - Tool Error Output
- The text sent to standard error output during the execution of the external tool. (If it appears in gray, it's the output of a previously failing run which is preserved for your trouble shooting.)
Workflows
02-download_and_analyze_raw_fileKNIME Hub- Batch File Execution with External ToolKNIME Hub
- BLAST_The_TreeKNIME Hub
- EC2_connectionKNIME Hub
- EC2_connectionKNIME Hub
- Show all 20 workflows
Links
- Cannot Install Knime extension on MacOSby ptusch on 2019-12-03forum.knime.com/p/76039
- Excecute Excel Macroby ipazin on 2019-02-01forum.knime.com/p/53959
- Zip file and protect it with passwordby bruno29a on 2021-04-09forum.knime.com/p/120483
- Statistical Data Sampling for Auditsby mlauber71 on 2019-11-12forum.knime.com/p/74487
- Knime prdictions to PLCby AnotherFraudUser on 2020-05-26forum.knime.com/p/92416
- Show all 11 links
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.