Skip to main content

Get help for ARIS Process Mining functions and services

Create unique activity table

You must merge the activity tables you created for each extraction into a single activity table. ARIS Process Mining can process only one activity table per data set.

Procedure. Procedure

  1. Add a new transformation with ACTIVITIES as name and P2P as namespace.

  2. Add the following lines to the statement to add all Purchase requisition item activities to the new activity table.

    SELECT *

    FROM `PURCHASE_REQUISITION_ITEM.ACTIVITIES_PURCHASE_REQUISITION_ITEM`

  3. Click Preview to view all Purchase requisition item activities in the result table.

  4. Add the following lines to the statement to add all Purchase order item activities to the new activity table.

    UNION ALL

    SELECT *

    FROM `PURCHASE_ORDER_ITEM.ACTIVITIES_PURCHASE_ORDER_ITEM`

  5. Click Preview to view all Purchase requisition item activities together with all Purchase order item activities in the result table.

You have created a transformation that creates a single activity table that includes all Purchase requisition item and all Purchase order item activities.

Example 188.

The statement looks like this:

Transformation


Here you can find the sample transformation statement as an SQL code snippet. You can use the snippet to follow the described example: