Data Transformation
Data Transformation is the final stage of the Extraction lifecycle. Raw extracted data is transformed into a structured Event Log — the foundation for Process Mining and Analytics.
Access via Extraction → Data Transformation. A Data Extractor must already exist before creating a transformation.
Click Create, provide a Transformation Name and select the Data Extractor. The transformation process consists of three steps:
Step 1: Configure Event Log Structure
Click Edit to configure the structure. Three mandatory fields are automatically included:
- Case ID
- Event Name
- Event Timestamp
Add optional columns: User, Department, Location, Amount, Vendor, Document Type, or any business-specific dimension. For each column define: Column Name, Data Type, Event Log Type. Then click Save → Execute.
Step 2: Configure Activities
Activities define how data is transformed and inserted into the Event Log. Click Create, enter an Activity Name, and the Query Editor opens with three sections:
- Table Explorer – Tree-view of Extractors, Source Tables, and Data Views.
- Query Editor – Write SQL transformation logic (SELECT, JOIN, WHERE, INSERT, UPDATE, DESC).
- Output Panel – Query Results, Execution Logs, Validation/Error Messages.
💡 Create one Activity for each business event (e.g. PO Created, PO Approved, Goods Received) for better maintainability.
Execute Options
| Option | Description |
|---|---|
| Full Insert | Processes and inserts all records |
| Delta Insert | Inserts only delta records |
| Run | Executes query as written without Event Log insertion (for SELECT/UPDATE/DELETE/DESC) |
| Full Preview | Preview all records without modifying the Event Log |
| Delta Preview | Preview only new/modified records |
Keyboard Shortcuts
| Action | Shortcut |
|---|---|
| Find & Replace | Alt + H |
| Preview | Alt + P |
| Execute | Alt + X |
Step 3: Generate Event Log Artifacts
Click Generate Artifacts → Generate. This consolidates all transformed data, builds indexes, creates optimized artifacts, and prepares the Event Log for Process Creation.
Delta Transformation
Process only newly added or modified records. Use Delta Execute for incremental updates. Use Full Execute when running for the first time or rebuilding the Event Log. Use Compile to validate query syntax without processing data.
Data Model
Define relationships between extracted tables and the Event Log. Access via Data Transformation → Configure Data Model.
- Drag and drop tables from the Tables panel onto the canvas.
- Click Create Relationship.
- Select Source Column and Target Column. The relationship is automatically created.
Benefits: Reduces manual joins, improves data accessibility, simplifies Activity creation, enhances performance.
Data Views
Create reusable pre-joined datasets referenced within Activities. Access via Data Transformation → Configure Data Views → Create. Use a CREATE TABLE statement. Data Views can include Joins, Filters, Calculated Columns, and Aggregations. Multiple Activities can reuse the same Data View.
Additional Actions
- Export Event Log – Download as CSV via email. Available from the Transformation List → Download icon.
- Add Extractors – Link a Transformation to multiple Extractors. New tables become available in the Query Editor.
- DESC Command –
DESC TABLE_NAMEorDESCRIBE TABLE_NAMEto inspect table structures. - Find and Replace – Available via the Find & Replace icon in the Query Editor.
- Multi-Select Delete – Select multiple Activities using checkboxes and delete simultaneously.