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