Log Transformation

[manish_mohan]

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

[tomljh]

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)

best
tomljh

[manish_mohan]

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