This deprecated node provides a powerful range of Script-based data transformation capabilities, including filtering the set of fields and rows to be output, and transforming the types or values of output data.
The following Script snippets show how to achieve common tasks:
Filtering on row values
emit *where 'Status' != "Inactive"
Filtering on row values
emit *where 'Billing_Total' > 100.00 and 'Status' == "Active"
Excluding fields
emit *exclude 'Billing_Ref', 'Company_Code'
Outputting selected fields only
emit 'Billing_Total', 'Customer_ID'
Renaming a field
emit *rename 'Customer_Ref' as "Customer_ID"
Changing the data type of a field
_ACCOUNT = Account_Number.int()emit *override emit _ACCOUNT as "Account_Number"
emit * outputs all input fields and their data by default. Use emit with field names to export chosen fields only.
where allows you to specify conditions to be met in order to output data rows.
exclude allows you to exclude fields from the output.
rename allows you to rename fields in the output.
override emit allows you to modify data passed to output.
Properties
Script
Specify Script to determine how to transform and output data.
Inputs and outputs
Inputs: in1.
Outputs: out1, multiple optional.