0 ×

Add Table To R

KNIME R-Project nodes version 3.7.0.v201810230750 by KNIME AG, Zurich, Switzerland

The data table from the input port is imported into the R workspace as variable knime.in; existing variables are overwritten in case of a conflict. The node outputs an R workspace containing the updated variables.

More details about R:
http://www.r-project.org/
Short-refcard.pdf

Options

R Snippet

R Script
The code being executed in R. Code may be executed in full or in part using the Evaluate Script and Evaluate Selection options respectively. Output will be printed to the console.
Column List
The list contains the column that are available in the input table. Double click any of the column names to insert the respective field in the expression editor. It will replace your current selection or simply insert at the current caret position.
Flow Variable List
The list contains the flow variables that are currently visible to the node. Double clicking any of the entries will insert the respective identifier at the current cursor position in your expression editor, replacing the current selection.

Templates

Category
A template category defined by the author.
Title
Name of the template.
Description
A brief overview of the purpose of the template.
Preview
The code to be applied to your expression editor.

Advanced

Send Row Names to R
Whether to send the row names from KNIME to R. Disabling this can improve performance with very large tables. Row names of knime.in will instead be default R row names: 1:n.
R type for knime.in
By default knime.in is data.frame. For large input tables, using data.table is likely more memory efficient especially while sending the input data to R and may therefore be faster. Please be aware that the support for data.table is experimental (!) and requires the "data.table" R package to be installed. It may not work for some R scripts, may slightly change or even be removed entirely in a future version.
Send batch size
The input of the R node is sent in row batches (default, 10 000 rows at a time). This is the amount of rows KNIME will retain in memory at any given time. For large tables, a higher batch size may be faster, but will require additional memory. Be aware, that R will likely keep all of the input table in memory and this only helps with memory during transmission of data to R.

Input Ports

R Input
Data Table Input

Output Ports

R Output with appended data

Views

R Std Output
The text sent to standard out during the execution of R executable as well as the text of the .Rout file generated by R.
R Error Output
The text sent to standard error during the execution of R executable as well as the text of the .Rout file generated by R. (If it appears in gray, it's the output of a previously failing run which is preserved for your trouble shooting.)

Best Friends (Incoming)

Best Friends (Outgoing)

Update Site

To use this node in KNIME, install KNIME R-Project nodes from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.