Ruby Script

Options

Script output

Append columns to input table spec

If checked, the columns as given in the list are appended to the input table specification. The number of columns in the output table equals the number of input columns plus the number of columns as given in the list. If unchecked, the output table will have exactly the same number of columns as given in the list.

Column list

Specify the column name and type of all result columns. After adding a new column, click on the name or type to change its value.

Script

$in_data_0

The input DataTable containing all available input from input port 0.

$out_data_0

Output container housing the outgoing DataTable for output port 0. This must be populated with rows by the script or else there will be no output from the node.

Example use to copy all input row of DataTable:

  $in_data_0.each do |row|
    $out_data_0 << row
  end

Example use to extend input rows by new columns:

  count = $in_data_0.length
  $in_data_0.each_with_index do |row, i|
    $out_data_0 << (row << Cells.new.string('Hi!').int(row.getCell(0).to_s.length))
    setProgress "#{i*100/count}%" if i%100 != 0
  end

Example use to create new DataTable from custom data:

  $in_data_0.each do |row|
    $out_data_0 << Cells.new.string(row[0].to_s.length.to_s)
  end

Input Ports

Table that the Ruby script will operate on.

Output Ports

Table containing the results of the Ruby script.

Best Friends (Incoming)

• Unpivoting (18 %) 
• Rule-based Row Filter (18 %) Streamable
• Column Rename (9 %) Streamable
• String Manipulation (9 %) Streamable
• String to Date/Time (legacy) (9 %) Streamable
• Show all 9 recommendations

Best Friends (Outgoing)

• GroupBy (20 %) 
• Reference Row Filter (20 %) 
• Rule-based Row Filter (20 %) Streamable
• Java Snippet (simple) (20 %) 
• Extract Time Window (legacy) (20 %) 

Workflows

• KNIME_​Ruby_​Test (ruby4knime) 

Installation

To use this node in KNIME, install Ruby Scripting Extension from the following update site:

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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.