This node allows you to execute arbitrary java code to create new columns or replace existing ones. Enter the java code in the text area.
\n \t\t\t\nOutput columns are defined by creating and binding a java field for each column. The value assigned to this field will be written to the output.
\n \t\t\t\nThis node allows adding or modifying flow variables in the same manner.
\n \t\t\t\nIt is also possible to use external java libraries (libraries that are not part of java boot classpath). In order to include external jar or zip files, add their location in the "Additional Libraries" tab.
\n \t\t\t\nAdvanced users may want to make use of a library that is already present in the KNIME Analytics Platform installation as a bundle. Adding them to the list in the "Additional Bundles" tab will make them available to the java snippet's classpath.
\n \t\t\t\nYou can define reusable templates with the "Create templates..." button. Templates are stored in the user's workspace by default and can be accessed via the "Templates" tab.
\n \t\t\n \n ","shortDescription":"Calculates a new columns or flow variables based on\n\t\tjava code snippets.","keywords":[],"deprecated":false,"streamable":true,"tags":["Scripting","Java","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6QkMxMjk0NUU0NUM2MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6QjFFNjI2MUM0NUM2MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpiMjZmMjcxNS1kZmZiLTRlYTgtYWJjMi0xZDk4N2YzMzE1NzIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+GBI7pwAAAJNJREFUeNpiYmBg+I+OgQBEMBACIDVMMMXImhgZGWG62QgZwoRLAmQIEPwCMpnJMgDJkL9kG4AHrIKGFwMLtoBBcgED2WFALGDBZgsxUQg3gBTFNHEBRkLCphkqBiI6sKZILEkZDNCSNUwext6NNSljcwHUm2FIms8CcTpY7j8eD4M0AqUZcaUHsAtokg5IAQABBgDSc3xHvbV83QAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"An input table","description":"Input table."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Appended table","description":"Input table with additional or replaced columns."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Java Snippet","sectionDescription":"Contains the Java code editor to edit the snippet.","fields":[{"name":"Column List","description":"This list contains the columns that are available in the input table. Double click any of the entries to insert a respective field in the code editor and insert the field name at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Flow Variable List","description":"This list contains the flow variables that are currently available at the node input. Double click any of the entries to insert a respective field in the code editor and insert the field name at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Snippet text area","description":"Enter your java code here. You can access input columns or flow variables by defining them in the "Input" table of the dialog. Alternatively use the methods getCell(name, type) or getFlowVariable(name, type) where name is the name of the input column or the flow variable. You can use the following values for the type parameter.
\nJava Snippet Code
\nFor columns:
\nFor flow variables:
\n* For these methods there is a variant that takes the column index instead of its name.
\nNote that the snippet allows defining custom global variables and imports.
\nExceptions in the snippet are caught by the framework and will result in missing values for all output columns of the row being processed—unless there are flow variables defined by the snippet (in which case the execution will always fail). You can force the node to fail execution by throwing an exception of class Abort .
\nCode Assistance
\nCTRL+SPACE for auto completion will popup a list with all classes, methods and fields available at your current cursor location.
\nENTER will generate missing import statements for a selected class.
","optional":false},{"name":"Input","description":"Define input fields for the snippet here. Every field will be populated with the data of the associated input column or flow variable during execution. For missing values in the input the field is set to null .","optional":false},{"name":"Output","description":"Define output columns and flow variables here. Every row in the Output table defines a java field bound to an output column or flow variable. Values assigned to this field in the snippet will show up at the output.","optional":false}]},{"sectionName":"Additional Libraries","sectionDescription":"This tab allows adding custom java library archives to make them available on the classpath of the java snippet.","fields":[{"name":"Library List","description":"List of libraries that will be present in the snippets classpath. Use the buttons below to add or remove libraries.","optional":false},{"name":"Add File(s)...","description":"Add a .jar or .zip file from your system.","optional":false},{"name":"Add KNIME URL...","description":"Add a KNIME protocol url to a .jar or .zip file. E.g. "knime://knime.workflow/example.jar".","optional":false}]},{"sectionName":"Additional Bundles","sectionDescription":"This tab allows making installed bundles available on the classpath of the java snippet, allowing you to use classes e.g. from org.apache.commons, org.json, com.google.guava and more.\n