Transforms allow you to format data so that it can be imported into EngageIP. Transforms can be be as simple as trimming whitespace to more complex cases combining multiple fields and applying a formula before importing into EngageIP. There are two distinct stages at which point a transform can take place: extracting the data from a file and importing into EnageIP. The differences are noted below.
Field transforms allow you to format the data as it is read from the incoming file. Examples of transforms at this phase of an import are:
|Case Conversion||Allows you to convert the file's data to upper, lower, or title|
|Conditional||Perform conditonal logic based on a comparison|
|Date Conversions||Format a date/time|
|Regex||Use regular expressions to format data|
|Substitute||Replace incoming data|
|Time||Convert to 24 hour format|
|Trim||Remove white space left or right of the data|
Mapping transforms are used to format data before importing as an EngageIP object. Transforms can be applied to single fields or used to combine fields. The results of a transform can also be mapped to a property of an EngageIP object, chained together using another transform, or both at the same time! Thus, it is possible to map many input fields into a single field in EngageIP or map a single input field into many EngageIP fields.
|Combine||Combines multiple input fields into a single string with formatting|
|Formula||Apply a formula to a input value or combination of input values|
|Literal||Default the value of the EngageIP property|
|Map||Uses a data map to import file values to values that are valid in EngageIP|
|Map to ID||Uses a data map to import file values to an ID in EngageIP|
|Match||Finds the EngageIP ID by name using the import field value|