Community

How to create the activity table?

In projects I have been, clients describe all the activities in its process and then we create the activity table inside the tool by SQL, PQL or others as follows:

  CREATE TABLE 'activitytablename' (
       CASE_KEY     VARCHAR(80),
       ACTIVITY       VARCHAR(200),
       EVENTTIME   DATETIME,
       SORTING        INT

INSERT INTO "activitytablename" ("CASE_KEY", "ACTIVITY", "EVENTTIME", "SORTING")
SELECT
    "source table"."Identificator"                                    AS "CASE_KEY",
    'First_activity_name'                                                  AS "ACTIVITY",
    "source table"."date_of_activity"                             AS "EVENTTIME",
    10                                                                                    AS "SORTING"
FROM "source table"

In Timeline, how do you create it?

Was this article helpful?

0 out of 0 found this helpful

Comments

3 comments

  • Avatar
    Nikolai Kromm

    Hello,

    The basic way to start with a Process Analysis project is to upload prepared CSV files manually. 

    Note. In addition to the manual file upload, you can import data to the project using different data sources or upload processed data from Repository.
    For details, see:
    Data Sources
    ETL in the Cloud

    0
  • Avatar

    Hi Nikolai, thanks for your quick response. My problem is because most of clients have not defined their activity table and therefore we have to do it into the process mining tool. In Timeline is not possible to create from zero this table, we must uploaded it already created?

    0
  • Avatar
    Nikolai Kromm

    Hello,

    Could you please give a small example of the raw data?

    • Please note, that if the data is sensitive, we should discuss it in the support ticket.
    0

Please sign in to leave a comment.