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?
Comments
3 comments
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
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?
Hello,
Could you please give a small example of the raw data?
Please sign in to leave a comment.