This node allows you to execute arbitrary Perl script to create a new column or to replace an existing one.
The preface script is run once before the data from the input table is read. It can be used to define variables which will be available in the body script.
The body script is run for each row. The predefined variables
$ROWKEY and $ROWINDEX give the key of the row
and its index, respectively. To address certain input values
use the predefined hash $column.
For instance, the value of the column with name frequency
can be obtained by $column{'frequency'}. When
frequencies is a collection cell,
$column{'frequencies'} is a reference to an array so
that the first element
of frequencies can be obtained by
$column{'frequencies'}[0]. Note, that the character "'"
in the column name must be escaped by "\'".
Beside the predefined hash $column there is an array
called $column_names which holds column names
(the keys of $column) in same order as in the input table.
The output of your script is the value of the last expression, or
can be specified by the return statement.
Please, return a reference
to an array when the output is of collection type, or undef
when the output should be a missing cell.
Options
Perl Script
Perl Executable
Popular Successors
- R Snippet5 %
- Nominal Value Row Filter4 %
Table Row to Variable4 %CSV Writer4 %- Perl Scripting4 %
- String to Number4 %
Row Splitter (deprecated)3 %- Reference Row Filter2 %
- RowID2 %
- R Snippet (2:1)2 %
Table Row To Variable Loop Start2 %- CSV Writer2 %
Loop End2 %- Column Renamer2 %
- Column Resorter2 %
- Column Filter2 %
Row Filter (deprecated)2 %- GroupBy2 %
- Joiner2 %
- Missing Value2 %
Column Rename2 %- String Manipulation2 %
CASE Switch Data (Start)2 %- Excel Writer2 %
- Split Collection Column1 %
Cell Splitter1 %- Column Merger1 %
- Parallel Chunk Start1 %
- External SSH Tool1 %
- Add Table to R1 %
- GET Request1 %
- Java Snippet1 %
- Group Loop Start1 %
- Fuzzy c-Means1 %
- Cross Joiner1 %
Joiner1 %- Ungroup1 %
- Rule Engine1 %
- Chunk Loop Start< 1 %
Number To String< 1 %String To Number< 1 %- Constant Value Column< 1 %
- Duplicate Row Filter< 1 %
- Partitioning< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Table Indexer< 1 %
Excel Writer (XLS)< 1 %- Columns to JSON< 1 %
- R View (Table)< 1 %
- String to XML< 1 %
- RDKit From Molecule< 1 %
- Plate Heatmap Viewer< 1 %
Table Column to Variable< 1 %- Table Row to Variable< 1 %
Database Writer< 1 %Table Writer< 1 %- Loop End (Column Append)< 1 %
Variable Loop End< 1 %- Concatenate< 1 %
- Column Combiner< 1 %
Column Appender< 1 %- Column Rename (Regex)< 1 %
- Table Validator (Reference)< 1 %
- String Replacer< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Crosstab< 1 %
- Interactive Table (legacy)< 1 %
- Table to Spark< 1 %
- One Row to Many< 1 %
- Random Matcher< 1 %
- Similarity Search< 1 %
- JPython Script 2:1 (Legacy)< 1 %
Excel Writer (XLS)< 1 %- Strings to Document< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- String to JSON< 1 %
- Table to R< 1 %
- POST Request< 1 %
- String to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- Fingerprints< 1 %
- Mass Calculator< 1 %
Views
- This node has no views
Workflows
- No workflows found
Links
- No links available
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.