However, the sheer potential scope of transformations can be daunting, and so we have created this reference guide to explain the requirements and potential applications of each transformation, along with examples of how they can each be applied to your data extracts.
Throughout the Transformation Reference, we provide input/output examples to illustrate one or more potential applications for each transformation, and what the final data set will look like.
For example, if you wanted to add a new fixed-value column field to a data extract, with an initial dataset as follows...
...you would use the "Addfield" transformation:
b. "Field Value" is the fixed value that each cell should contain.
c. "Field Index" sets where the new column will appear. Index values start at 0 for the leftmost column, and progress in integers from there (1 for the next column, then 2, etc.)
This transformation, applied to the above dataset, would produce the following output table:
I Ain't Afraid of No Code!
Transformations are performed by scripts, and for those familiar with scripting language it is possible to access the source code directly. This section is highlighted red to stress that it is not necessary to deal directly in the coding language (everything can be achieved within the GUI), but the potential is there for those that wish to take advantage of it, and here we will explain the function and format of each parameter variable.
Each variable is listed according to a code, Parameter > Format > Name. Available formats are:
|str (string)||An open field that can contain either letters or numeric characters, but cannot be used in calculations as the system will always consider it a string.|
|boolean||True / False switch.|
|datetime||A date/time value, which should be input in the format:
|list||A list of objects. Depending on the specific transformation, this list may be comprised of strings or integers. Default list formatting uses .json conventions.|
|int (integer)||A field that will only recognize numeric characters, and can be used as the basis for calculation transformations (e.g. sum).|
|float||A non-integer numeric (e.g. accepts decimal point values).|
|currency||A numeric field that also carries a currency denomination.|
|long||An extended string field, capable of holding up to 32 bits.|