February 23
Data Transformer enables raw data extracted from a document to be transformed, cleaned, and normalized into the viable format required for the data to move downstream. The raw data extracted from your documents may not be in the format you need to action your data.
Transformations are comprised of several Value Cleanup, Text Transform and Conditional Logic tools that complement Patterns Studio to allow you to transform extracted data into your desired format.
See the table for a list of all tools available in Transformation Builder๏ปฟ:
Tool Type | Tool | Description |
---|---|---|
Value Cleanup | Extract Text (From Value) | Further trim an extracted value using Regex |
Value Cleanup | Append to Value | Add plain-text to the end of extracted value |
Value Cleanup | Prepend to Value | Add plain-text to the start of an extracted value |
Text Transform | Convert to Uppercase | Capitalize all letters of an extracted value |
Text Transform | Convert to Lowercase | Change all extracted value letters to lowercase |
Text Transform | Capitalize First Letter | Capitalize the first letter of an extracted value |
Conditional Logic | Search & Replace | Replace any character/phrase with a new value |
Conditional Logic | Map Values | Transform extracted values using a user-defined โdictionary" |
The Create and Test Transformation๏ปฟ is also available in Data Transformer to enables users to test their Transformations within the Builder itself, without the need to reprocess any documents.