Transformation function reference

The add-on includes the following transformation functions that convert from one technical format to another:

• Date and time --> String

• Date --> String

• String --> Date

• String --> Date and time

• String --> Time

• Time --> String

Parameters: For each transformation function of this type you can use the parameter to format the function's output to meet business requirements. For example, specify that a date value is output as yyyy-MM-dd or dd-MM-yyyy.

The add-on includes the following:

Aggregate of integer numbers: takes as integers as input and outputs the sum of those integers. Parameters: N/A

Concatenate string: takes multiple strings as input and outputs them joined together as a single string. The output string is in the same order as the input fields. Parameters: the value to separate each input string.

Split string: takes a string contained in a single field and outputs parts of the string to other fields. A delimiter is used to tell the system how to partition the string. For example, a full name field might be split into first and last fields using the space character as a separator. Parameters: the separator used to determine where the string is split.

Constant value: you supply a value which this function outputs to the given field. Parameters: the data type and value to output.

Cross reference: looks up the value and outputs a value contained in a cross reference table. Parameters: the location of the source and target fields.

Digital asset UUID lookup: takes file names in the import source, looks up their UUIDs, and attaches the corresponding digital assets to the target field. Instead of having to manually open and attach assets to records, this function allows you to perform a bulk import operation to attach digital assets. The digital assets must already be located in a Drive. For instructions on completing this task, see the TIBCO EBX® Digital Asset Manager Add-on documentation.