Description
A Script Column node transforms data through a script.
Configuration Options
Basic Configuration Options
| Setting |
Description\Parameters |
Script Type |
The scripting language. R or Python. |
Script |
The script to run. Any code should be placed in the section denoted by "#Place your code here". This node expects a dataframe assigned to frame at the end of this section. |
Advanced Configuration Options
| Setting |
Description |
Column Data Type |
This setting can be overridden. |
Node Specific Snippets
| Setting |
Description |
Script Snippets |
Typing @R (R) or @P (Python) within the script editor prompts the user for several node-relevant snippets. |
Parameters |
Typing # within the script editor prompts the user for a list of available parameters. |
@input_path |
The input path notation is a string representation of the input file for the scripting node. The input file contains the output from the upstream dataframe. |
@input_path_1 |
This path notation is used when there are multiple input nodes. input_path_1 indicates the first connected upstream node output. input_path_2 is the second connected upstream node output. For additional connected nodes increase the trailing number as needed. |
@output_path |
The output path notation is a string representation of the output file for the scripting node. |
@path('/home/other') |
The path notation can be used to reference DataWORQ virtual paths. This notation will convert the virtual path to the physical path upon execution. |
Actions
| Action |
Description |
Infer Data Types |
Automatically infer the data types used for each column. These data types can be overridden in the advanced section. |
Preview |
Once the node is configured, the combined result set can be previewed at any time. |