This content has been marked as final. Show 3 replies
I'm analyzing some of our system logfiles in order to identify bottlenecks. My (simplified) data model contains the fields ItemID, ActionType and Timestamp.
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!