Miscellaneous Transformation Functions - Page 1

Accumulate Strings

This function concatenates value with previous value

Calculation

Scripting provides a flexible way of transforming the data. Both Pascal or Python can be used.

Case Transformation

This function provides a flexible way of transforming the data based on input values

Checksum

Creates checksum of a string

Command Line Parameter

Returns command line parameter. Aetl.exe script.ats parameter2 parameter3 parameter4

Compare Values

Compares two values using various options

Concatenate

Joins several values into one value delimited by Delimiter and surrounded by a Qualifier if specified

Create New File

Forces a new file creation when field value changes

Field Value

Returns the value of a specific field from the delimited string

Get Excel Cell Value

Extracts Cell value from an excel file

Get Excel Cell Value Dynamic

Extracts single cell value from an excel file

Get File Content

Returns file content

Get File Content Dynamic

Returns file content using parameter as file name

Get Package Variable

Returns value of a package variable

Get Variable

Returns value of variable

www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License