Skip to end of metadata
Go to start of metadata

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

binaryBinary

Data

bitBitData
boolBooleanLogical
int

Integer

Numerical
doubleDoubleNumerical
floatFloatNumerical
long

Long

Numerical
dateDateDate & Time
timespanTimespan (Date with a time)Date & Time
string

String

String
arrayArrayCollection
dictionaryDictionary (also known as a map)Collection
instanceInstance in a data source or targetSchema
nodeNode in a schema of a data source or targetSchema
typeAny of these typesData
nullNull valueData
varVariable reference, either local or globalScript