This node allows you to execute arbitrary java code to create
a new column or to replace an existing one. Enter the java code in
the text area. To address certain input values of the table
use $name_of_col$ (a double click on the elements in the
column list will insert a the place holder at the current cursor
position). For instance, the sum of the first two columns is
$col_1$ + $col_2$ (replace col_1 and col_2 by the
name of the columns). Please also specify the return type with one
of the radio buttons. You can also use more complex
statements such as if-else switches. For instance, to bin a numeric
column you could enter code as follows and check the String return type:
String bin;
if ($col_1$ < 0.5) {
bin = "Very small";
} else if ($col_1$ < 2.0) {
bin = "Small";
} else if ($col_1$ < 10.0) {
bin = "Medium";
} else if ($col_1$ < 20) {
bin = "Large";
} else {
bin = "Very Large";
}
return bin;
You can also use static methods of java utility classes, e.g. to get a
column with random values, simply enter Math.random() and
check the double return type.
It is also possible to use external java libraries (that is, libraries that are not part of java boot classpath). In order to include such external jar or zip files, add their location in the "Additional Libraries" tab using the control buttons.
Exceptions in the snippet are caught by the framework and will
result in a missing value for the current row. If the snippet
throws an exception of class Abort (an inner class that
is available to each snippet without further import statements),
the entire execution will halt, using the exception message
as error that is presented to the user.
Options
Popular Successors
- Joiner4 %
- GroupBy3 %
- Column Filter3 %
- Java Snippet (simple)3 %
- Concatenate3 %
Table Row To Variable Loop Start2 %Row Filter (deprecated)2 %Number To String2 %- Chunk Loop Start1 %
- Line Plot (legacy)1 %
- Group Loop Start1 %
- k-Means1 %
- Numeric Row Splitter1 %
- Java Snippet1 %
- X-Partitioner< 1 %
- Rule-based Row Filter< 1 %
- Table Difference Checker< 1 %
Column Rename< 1 %- Row Sampling< 1 %
- String Manipulation< 1 %
Variable to Table Column< 1 %- Rule-based Row Splitter< 1 %
- One to Many< 1 %
- Reference Row Filter< 1 %
- Column Splitter< 1 %
- Math Formula< 1 %
- Excel Writer< 1 %
- Fingerprints< 1 %
- Column Resorter< 1 %
- Rule Engine< 1 %
- Counter Generation< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- End IF< 1 %
- Java Distance< 1 %
- Send to Tableau Server< 1 %
- Table Row to Variable< 1 %
Linear Correlation< 1 %Column Filter< 1 %- XPath< 1 %
- HTML Parser< 1 %
- Loop End< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
Row Splitter (deprecated)< 1 %- Column Expressions< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Create Bit Vector< 1 %
- Google Sheets Updater< 1 %
- UNIX Timestamp to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
Database Delete< 1 %- Table Writer< 1 %
PCA< 1 %- Value Counter< 1 %
- Extract Table Dimension< 1 %
Send to Power BI< 1 %- Columns to JSON< 1 %
- Time to String (legacy)< 1 %
CSV Writer< 1 %- Nominal Value Row Splitter< 1 %
- Table Transposer< 1 %
- Statistics< 1 %
- Numeric Distances< 1 %
- Line Chart (JFreeChart)< 1 %
- POST Request< 1 %
- Google Address Geocoder< 1 %
- Variable to Table Column< 1 %
- Read Images< 1 %
Database Looping< 1 %- Java Edit Variable< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Cell Splitter< 1 %
- Subset Matcher< 1 %
- Denormalizer< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- Sorter< 1 %
- Unpivot< 1 %
- Similarity Search< 1 %
- Tag Cloud (JavaScript)< 1 %
- Table to JSON< 1 %
- Table to R< 1 %
- RDKit From Molecule< 1 %
Database Reader< 1 %Database Writer< 1 %Recursive Loop End< 1 %- Fuzzy Rule Learner< 1 %
- Decision Tree Learner< 1 %
PCA Apply< 1 %- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Cross Joiner< 1 %
- Reference Column Filter< 1 %
- Partitioning< 1 %
CASE Switch Data (Start)< 1 %- Random Number Assigner< 1 %
Table to HTML< 1 %- Math Formula (Multi Column)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Document Vector< 1 %
- GET Request< 1 %
- 2D/3D Scatterplot< 1 %
Table Column to Variable< 1 %- CSV Writer< 1 %
Recursive Loop Start< 1 %Variable Loop End< 1 %Concatenate (Optional in)< 1 %Cell Replacer< 1 %- Column Renamer (Dictionary)< 1 %
- Duplicate Row Filter< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Normalizer< 1 %
- String Manipulation (Multi Column)< 1 %
- Empty Table Switch< 1 %
- Color Manager< 1 %
- Shape Manager< 1 %
- SDF Stripper< 1 %
- SDF Writer< 1 %
- Parallel Chunk Start< 1 %
- MoSS< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Filter< 1 %
Tableau Writer (TDE)< 1 %- Strings to Document< 1 %
- String to Path< 1 %
- ROC Curve (JavaScript)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
Find Elements< 1 %- Advanced MolConverter< 1 %
- Bi Reactor< 1 %
- Chemical Terms< 1 %
- MolExporter< 1 %
- Text Extractor< 1 %
- Split Collection Column< 1 %
- Breakpoint< 1 %
Table Row to Variable< 1 %Database SQL Executor< 1 %Database Table Creator< 1 %Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Recursive Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- X-Aggregator< 1 %
- Silhouette Coefficient< 1 %
- Category to Number< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Table Validator< 1 %
- Equal Size Sampling< 1 %
- Row Filter (Labs)< 1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Number to String (PMML)< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Renderer to Image< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Send Email< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Parameterized DB Query Reader< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Bar Chart (JFreeChart)< 1 %
- JPython Function (Legacy)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- Term Co-Occurrence Counter< 1 %
- Frequency Filter< 1 %
- N Chars Filter< 1 %
Punctuation Erasure< 1 %- Dictionary Tagger< 1 %
- String to Path (Variable)< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Object Inserter< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- String to Date&Time< 1 %
- Modify Date< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- Column to XML< 1 %
- RDKit Fingerprint< 1 %
- RDKit Two Component Reaction< 1 %
HTTP Retriever< 1 %- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
- Catch Errors (Data Ports)< 1 %
Recursive Loop Start (2 ports)< 1 %- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Predictor (Regression)< 1 %
- Column Comparator< 1 %
- Column Name Extractor< 1 %
Double To Int< 1 %- Shuffle< 1 %
- Rule Engine (Dictionary)< 1 %
- DB SQL Executor< 1 %
- External Tool< 1 %
- Java Edit Variable (simple)< 1 %
- JSON Path< 1 %
- Feature Inserter< 1 %
- Add Table to R< 1 %
- Date&Time to String< 1 %
- Time Difference (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- String Similarity< 1 %
- Save File Locally< 1 %
Python Snippet< 1 %- Conformers< 1 %
- logD< 1 %
- MarvinView< 1 %
- Create Collection Column< 1 %
Table Row to Variable< 1 %Parameterized Database Query< 1 %Generic Loop Start< 1 %- Recursive Loop Start< 1 %
Naive Bayes Learner< 1 %- K Nearest Neighbor< 1 %
- Linear Regression Learner< 1 %
- SMOTE< 1 %
Gradient Boosted Trees Predictor< 1 %- Random Forest Predictor< 1 %
- Expand Bit Vector< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
CASE Switch Model (Start)< 1 %CASE Switch Data (End)< 1 %- Scatter Plot (legacy)< 1 %
- Stresser< 1 %
- Matrix Distance< 1 %
- Distance Matrix Calculate< 1 %
- Bar Chart (JavaScript)< 1 %
- Histogram (JavaScript)< 1 %
- Document Data Extractor< 1 %
Strings To Document< 1 %- Term Vector< 1 %
- Heatmap (JavaScript)< 1 %
- XML to JSON< 1 %
JSON Writer< 1 %Python Learner< 1 %Python Script (2⇒1)< 1 %- Molecule to CDK< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Outlier Removal< 1 %
Python Plot< 1 %- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %- Image Writer (Table)< 1 %
- Table Reader< 1 %
Interval Loop Start< 1 %- Naive Bayes Learner< 1 %
- DBSCAN< 1 %
Regression Predictor< 1 %- Association Rule Learner< 1 %
- Many to One< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Reference Column Splitter< 1 %
- Column Filter (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Rule Engine Variable< 1 %
- One-way ANOVA< 1 %
- Single sample t-test< 1 %
Merge Variables< 1 %Color Appender< 1 %- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- SDF Inserter< 1 %
- DB Insert< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Matcher< 1 %
- Line Plot (Plotly)< 1 %
Table to PDF< 1 %- GroupBy Bar Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
XLS Reader< 1 %- Punctuation Erasure< 1 %
- Stanford Tagger< 1 %
- Term to String< 1 %
- String to JSON< 1 %
- Projector< 1 %
- Image to Labeling< 1 %
- Node Name Filter< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒1)< 1 %Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Date Field Extractor (legacy)< 1 %
- Molecular Properties< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Molecule Fragmenter< 1 %
- Text Classifier Predictor< 1 %
Location Extractor< 1 %- Latitude/Longitude to Coordinate< 1 %
- URL Resolver< 1 %
OAuth< 1 %Write MDB< 1 %- Generate 2D Coordinates< 1 %
- ICon< 1 %
- SDF Writer< 1 %
- KNIME Server Connection (legacy)< 1 %
- Speedy SMILES Ring Count< 1 %
- Speedy SMILES Convert to Scaffold< 1 %
- Benchmark End< 1 %
- PDB Saver< 1 %
- Inject Column Properties< 1 %
- Random Numbers Generator< 1 %
- PDB Downloader< 1 %
- Matlab Snippet< 1 %
Open in Python< 1 %- Elemental Analysis< 1 %
- JC4XL Writer< 1 %
- Major Microspecies< 1 %
- MolSearch< 1 %
- Set MolName And Comment< 1 %
- Aqueous Solubility< 1 %
- Standardizer< 1 %
- Structure Checker< 1 %
- Tautomers< 1 %
- MolConverter< 1 %
- ARIMA Learner< 1 %
- Extract URI Info< 1 %
- File Meta Info (legacy)< 1 %
- Upload (legacy)< 1 %
- URL to File Path< 1 %
- Wait...< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
- ARFF Writer< 1 %
CSV Reader< 1 %Database Table Connector< 1 %Database Update< 1 %Table Reader< 1 %Table Writer< 1 %- Table Creator< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %- Fuzzy c-Means< 1 %
- Hierarchical Cluster Assigner< 1 %
- Decision Tree to Image< 1 %
Decision Tree Learner< 1 %- Polynomial Regression Learner< 1 %
- Regression Predictor< 1 %
Scorer< 1 %- Numeric Scorer< 1 %
- SVM Learner< 1 %
- SVM Predictor< 1 %
Random Forest Learner< 1 %- Random Forest Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Add Empty Rows< 1 %
- Binner (Dictionary)< 1 %
- Bootstrap Sampling< 1 %
Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- Category to Number (Apply)< 1 %
- Number to Category (Apply)< 1 %
String To Number< 1 %- String to SVG< 1 %
Column Appender< 1 %- Column to Grid< 1 %
- Linear Correlation< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Row Splitter (Labs)< 1 %
- Normalizer (Apply)< 1 %
Normalizer< 1 %- Denormalizer (PMML)< 1 %
Number To String (PMML)< 1 %String To Number (PMML)< 1 %- String to Number (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
String Replace (Dictionary)< 1 %- Ruleset Editor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Cronbach Alpha< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Independent groups t-test< 1 %
- CASE Switch End< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Save Workflow< 1 %
Parquet Writer< 1 %- Parallel Chunk End< 1 %
- MySQL Connector< 1 %
- DB Delete (Table)< 1 %
DB Loader< 1 %- DB Query Reader< 1 %
- DB Update< 1 %
DB Table Creator< 1 %- Conditional Label Assigner< 1 %
- Random Boolean Assigner< 1 %
- Bit Vector Distances< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
PMML Predictor< 1 %- OpenBabel< 1 %
- Generic Web Service Client< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Index Query< 1 %
- Geo-Coordinate Row Filter< 1 %
XLS Sheet Appender< 1 %XLS Writer< 1 %Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Excel Cell Updater< 1 %
R Snippet< 1 %- Tableau Writer< 1 %
Word Vector Apply (legacy)< 1 %- TF< 1 %
- Category to Class< 1 %
- Chi-Square Keyword Extractor< 1 %
- String Matcher< 1 %
- Tika Language Detector< 1 %
- Modifiable Term Filter< 1 %
- RegEx Filter< 1 %
- Snowball Stemmer< 1 %
Stop Word Filter< 1 %- Dictionary Tagger (Multi Column)< 1 %
Document vector< 1 %- String to Term< 1 %
- Tags to String< 1 %
- Document Viewer< 1 %
- Tag Cloud< 1 %
- Weka Predictor (3.7)< 1 %
- External Tool (Labs)< 1 %
- Google Sheets Appender< 1 %
- JPMML Classifier< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
Simple Table View (JavaScript)< 1 %- JSON to XML< 1 %
- Min Filter< 1 %
- Label Transformer< 1 %
Python Script (2⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
- R Snippet< 1 %
- R View (Table)< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Window Loop Start< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Twitter Search< 1 %
- Workflow Service Input< 1 %
XGBoost Linear Ensemble Learner (Regression)< 1 %- String to XML< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit To InChI< 1 %
- RDKit To Molecule< 1 %
- RDKit Remove Hs< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Substructure Filter< 1 %
- RDKit Substructure Counter< 1 %
- MapQuest Geocoder< 1 %
- URL Normalizer< 1 %
- HTTP Result Data Extractor< 1 %
- HTTP Retriever< 1 %
Web Searcher< 1 %- Navigate< 1 %
Views
- This node has no views
Workflows
_01_ChemicalLibraryEnumerationKNIME Hub- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 01_Clustering_the_Social_CommunityKNIME Hub
- Show all 640 workflows
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.