Formula Builder¶
Overview¶
You can enhance and refine your wizard-created data processes by using the Jitterbit Formula Builder to enter Jitterbit Scripts. Scripts have many uses.
For example:
- A script can be used in a transformation mapping to create a target data element from source data.
- You can manipulate any field's value during a transformation with a script.
- Free-standing scripts can perform a calculation or set project variables.
- With the Formula Builder, you can use mathematical operators, concatenate text strings, or use Jitterbit functions to perform sophisticated operations.
The Formula Builder includes a drop-down allowing you to view the tool's interface in either Business Analyst or Developer modes:
- Business Analyst mode will prompt you through a wizard to enter the required and optional parameters of a function.
- Developer mode bypasses the wizard and lets you directly enter the function definition into a script so that you complete its arguments in the script editor.
Data Types¶
These data types are supported in Jitterbit Scripts:
| Type | Description | Classification |
|---|---|---|
binary | Binary | Data |
bit | Bit | Data |
bool | Boolean | Logical |
int | Integer | Numerical |
double | Double | Numerical |
float | Float | Numerical |
long | Long | Numerical |
date | Date | Date & Time |
timespan | Timespan (Date with a time) | Date & Time |
string | String | String |
array | Array | Collection |
dictionary | Dictionary (also known as a map) | Collection |
instance | Instance in a data source or target | Schema |
node | Node in a schema of a data source or target | Schema |
type | Any of these types | Data |
null | Null value | Data |
var | Variable reference, either local or global | Script |
Functions Index¶
These indexes link to the specific documentation for each of the Jitterbit Script and Jitterbit JavaScript functions available in Jitterbit.
Jitterbit Script Functions¶
Note
- Single Agent Only: Functions marked as Single Agent only are to be used only with a single Private Agent as they do not work when using Cloud Agents or multiple Private Agents.
- Deprecated: Functions marked as Deprecated should no longer be used as they may be removed in a future version of Jitterbit.
JavaScript Functions¶
Note
- Single Agent Only: Functions marked as Single Agent only are to be used only with a single Private Agent as they do not work when using Cloud Agents or multiple Private Agents.
- Deprecated: Functions marked as Deprecated should no longer be used as they may be removed in a future version of Jitterbit.