Formula Builder in Jitterbit Design Studio
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.