3 Replies Latest reply: Aug 29, 2013 5:26 AM by Florian Pennetzdorfer RSS

    Load records depending on specific preceding records

    Florian 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).

      1.jpg

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

      2.jpg

       

      Please find the attached qvw.

       

      Thanks in advance!

      Regards, Florian