- Before you begin
- Managing access
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Process simulation
- Root cause analysis (Preview)
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Process Insights (preview)
- Creating apps
- Loading data
- Transforming data
- Autopilot™ for SQL (preview)
- Structure of transformations
- Tips for writing SQL
- Exporting and importing transformations
- Viewing the data run logs
- Merging event logs
- Configuring Tags
- Configuring Due dates
- Configuring fields for Automation potential
- Activity Configuration: Defining activity order
- Making the transformations available in dashboards
- Data models
- Adding and editing processes
- Customizing dashboards
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining user guide
Text
LEFT of
Description
Returns the leftmost characters from a text field or expression result. The number of characters returned is indicated by the numeric field or expression specified by LEFT.
Syntax
LEFT <Numeric field or Expression> characters of <Text field or expression>
Supported values
Only numeric values can be used for LEFT. Only text values can be used for characters of.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
LEFT 5 characters of Case type
RIGHT of
Description
Returns the rightmost characters from a text field or expression result. The number of characters returned is indicated by the numeric field or expression specified by RIGHT.
Syntax
RIGHT <Numeric field or Expression> characters of <Text field or expression>
Supported values
Only numeric values can be used for RIGHT. Only text values can be used for characters of.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
RIGHT 5 characters of Case type
SUBSTRING FROM
Description
Returns a part of the text field value or expression result. The number of characters to be returned is indicated by the numeric field value or expression result specified in characters long and the start position is defined by start position.
Syntax
SUBSTRING of <Text field or Expression>, <Numeric field or expression> characters long, start position <Numeric field or Expression>
Supported values
Only text values can be used for SUBSTRING. Only numeric values can be used for characters long and start position.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
SUBSTRING of Phonenumber = "1-800-123-4567", 3 characters long, start position 3 (Returns the 3-digit area code 800)
CONCAT
Description
Concatenates two or more text field values or expression results into one text value.
Syntax
CONCAT <Text field or Expression> + <Text field or Expression> [+ <Text field or Expression>]
Supported values
Only text values can be used.
NULL handling
NULL values are not included in the result. For example CONCAT('A', NULL, 'B') returns AB.
Example
CONCAT (Purchase_Order_ID,'-',Purchase_order_item_ID (creates a new CaseID by merging the Purchase_Order_ID and the Purchase-Order_Item ID.)
COALESCE
Description
Returns the first non-NULL value in a list of values defined by expressions, fields, or constants.
Syntax
COALESCE <Expression or Field or Constant> + <Expression or Field or Constant> [+ <Expression or Field or Constant>]
Supported values
All values can be used.
NULL handling
If all values in the list are NULL, then the COALESCE function will return NULL.
Example
COALSCE (Purchase_order_ID, Invoice_ID) (Returns the first non NULL value to check if there are Invoices created without a Purchase order.