Load records depending on specific preceding records

[pennetzdorfer]

Hey,

I'm analyzing some of our system logfiles in order to identify bottlenecks. My (simplified) data model contains the fields ItemID, ActionType and Timestamp.

The issue:

For each ItemID I would like to extract the Timestamp of the first occurence of ActionType A   -  under the condition that there already has been a preceding ActionType D (red records).

Please note that I need to do that in script! I would like to create a new table that should look like this:

Please find the attached qvw.

Thanks in advance!

Regards, Florian

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[arthur_dom]

I think you could do something like this: <attached>

[pennetzdorfer]

Thanks a lot!

Is it also possible to do the "converse":  extract the Timestamp of the last occurence of Action A before the first occurrence of Action D?  (please see red lines)

Thanks!