- Release notes
- 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
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Transforming data
- 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 process apps
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining
Description
LEFT.
Syntax
LEFT <Numeric field or Expression> characters of <Text field or expression>
Supported values
LEFT. Only text values can be used for characters of.
NULL handling
NULL, the result is NULL.
Example
LEFT 5 characters of Case type
Description
RIGHT.
Syntax
RIGHT <Numeric field or Expression> characters of <Text field or expression>
Supported values
RIGHT. Only text values can be used for characters of.
NULL handling
NULL, the result is NULL.
Example
RIGHT 5 characters of Case type
Description
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
SUBSTRING. Only numeric values can be used for characters long and start position.
NULL handling
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)
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.)
Description
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
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.
