Functions are vital part of the expression syntax in Loadit. Functions allow you to apply sophisticated calculations in a succinct and compact form.
These functions allow you to calculate values across an entire dataset rather than a single row
These functions are used to encode data, e.g. by flagging or converting to numeric coded values.
These functions operate on DateTime inputs to produce a result. For example, subtracting, adding and formatting DateTime values.
Lookup and Reference
The functions enable you to perform mathematical operations on your data
These functions allow you to apply logical conditions to your data
These functions are used to operate on text values. For example, replacing character, changing case, extracting values and so on.