- Release notes
- Before you begin
- 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
- 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
- Customizing process apps
- Publishing process apps
- App templates
- Additional resources
Data transformations
When you create a process app from an app template, you want to make sure the data used in the process app reflects your business process in the correct way. With Data transformations you can customize the data used for Process Mining.
You can either customize the transformations from within Process Mining using Data transformations, or you can edit them locally on your desktop, see Editing data transformations in a local environment
This page describes how to customize data transformations from within Process Mining. Data transformations are integrated in the dashboard editor. See Working with the dashboard editor.
Data transformations enable you to:
-
add new fields for
group by
and filters. For example, Quality check type. -
add events. For example, Invoice quality check done.
-
add tags. For example, Failed to meet SLA, Four eyes violation.
-
add business logic for calculating KPIs. For example,
Case_has_maverick_buying
.
-
Select the Data transformations button in the upper right corner of the dashboard editor to open the Data transformations.
If you open the in-line editor for the first time, it will take some time to load the editor.
The in-line data transformations editor is displayed.
-
Select Transformations to view the structure of the transformations and to display the
.sql
files.
See Structure of transformations for more information on the structure of the transformations.
.sql
file defines a new table in the data model. If you select the a .sql
file in the Transformations panel, the SQL query is displayed in the Transformations and a preview of the data file you are editing is displayed in the Preview panel.
When editing a query, you can see a preview of the data of the last time the query was run in the Preview panel.
If there are any unsaved changes in the transformations, the Save button is enabled. Select Save to save the changes. The status of the transofrmation will be set to Up to date.
You can select the columns you want to display in the Preview panel.
Follow these steps to change the visible columns.
Step | Action |
---|---|
1 |
Select Columns to display the list of columns. |
2 |
Select the columns you want to display in the Preview panel from the list. |
Log level |
Description |
Data run status |
Information |
An Information message contains helpful information on the progress of the datarun. |
Success |
Warning |
A Warning refers to a potential problem in your data that might affect what will be displayed on a chart in the published process app. It is advised to resolve any warnings to prevent any potential future problems. |
Success |
Error | An Error refers to a mistake in your data that prevents the process app from loading the data or running the transformations.
You must resolve all errors to enable a successful data run. |
Failed |
By default, Errors, Warnings, and Information messages are displayed when you open the Log. You can use the Filter menu to change the log level. See the illustration below for an example.
You can select the icon to copy the contents of the log file and paste in, for example, a Notepad file that you can save on your computer. This enables you to view the messages when working on solving the issues causing errors or warnings.
This also enables you to share the contents of the log file, for example if you need support.