Log Transformation

I am trying to transform a log into process mining log. The second image shows the raw data, the first image shows the expected output.

I am basically trying to merge 3 rows into one row with the values. but if there is an error in the raw data like absence of expected flow. i would like to discard that particular data.

Thank you in advance
Screenshot 2024-06-17 at 11.19.48

Hi @manish_mohan ,

Group the sequence according to the “start” string, dividing the original sequence into 4 groups. Then, using a setup of 3 columns and grouping, transform both the “timestamp” column and the “mode” column into a “grid” format for each group. Finally, merge the two resulting grids (tables) together.


example.knwf (20.1 KB)



This totally worked.
Thank you very much for your help.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.