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 Predecessors
CSV Reader7 %- GroupBy7 %
- Missing Value4 %
- Nominal Value Row Filter4 %
- Perl Scripting3 %
Excel Reader (XLS)3 %File Reader3 %- Reference Row Filter2 %
Column Rename2 %- Sorter2 %
Excel Reader (XLS)2 %- Column Filter2 %
- Tag Filter2 %
- Joiner2 %
Variable to Table Row2 %- Java Snippet2 %
- Column List Loop Start2 %
Row Splitter (deprecated)2 %Row Filter (deprecated)2 %- Table Transposer2 %
- Rule-based Row Filter (Dictionary)2 %
Variable to Table Column2 %- Column Rename (Regex)2 %
- Counter Generation2 %
- Table Difference Finder2 %
- Duplicate Row Filter2 %
- Table Creator1 %
String To Number1 %- RowID1 %
- DB Reader1 %
- Column Resorter1 %
- Rule-based Row Splitter1 %
Variable to Table Column< 1 %List Files< 1 %- String to Number< 1 %
- Row Sampling< 1 %
- One Row to Many< 1 %
- GET Request< 1 %
- Excel Reader< 1 %
- Group Loop Start< 1 %
- Concatenate< 1 %
- Cell Splitter By Position< 1 %
- Column Aggregator< 1 %
- Partitioning< 1 %
- Ungroup< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- Unpivot< 1 %
- End IF< 1 %
- JSON Path< 1 %
- RDKit To InChI< 1 %
- CSV Reader< 1 %
- Length< 1 %
- Load Text Files< 1 %
- Copy/Move Files (legacy)< 1 %
Table Reader< 1 %Joiner< 1 %- String Manipulation< 1 %
- Create Temp Dir (legacy)< 1 %
- SDF Reader< 1 %
- Math Formula< 1 %
- R Snippet< 1 %
- Date&Time Difference< 1 %
- FASTA Sequence Extractor< 1 %
- Groovy Script< 1 %
- R Snippet< 1 %
- Unzip Files (legacy)< 1 %
- URL to File Path< 1 %
Table Column to Variable< 1 %CSV Writer< 1 %Line Reader< 1 %Loop End< 1 %- Chunk Loop Start< 1 %
- Add Empty Rows< 1 %
Concatenate (Optional in)< 1 %Column Appender< 1 %- String Splitter (Regex)< 1 %
- Data Explorer< 1 %
- Data Generator< 1 %
SAS7BDAT Reader< 1 %- SAS7BDAT Reader< 1 %
- Document Data Extractor< 1 %
- Sentence Extractor< 1 %
- External Tool (Labs)< 1 %
- JSON Transformer< 1 %
- Python Source (legacy)< 1 %
- POST Request< 1 %
Extract Date&Time Fields< 1 %- RDKit Descriptor Calculation< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Table Validator (Reference)< 1 %
- Table Manipulator< 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.