Given a sequence of general to specific events (like product browsing a pages, followed by particular product pages). What is the best way to bring information from the browse events into the results for the product event? log example time=1 session=1 pageType=browse name=NewStuff resultsCount=3 time=2 session=1 pageType=product product=a time=3 session=1 pageType=product product=b In the example a user hit a browse page with three products, and clicked through on two of them. I would like to transform those events into a table like this: desire result | session | srcBrowseName | Product | | 1 | NewStuff | a | | 1 | NewStuff | b | Notice that I have to repeat data from the browse event for each of the product page events. I have an inkling that this could be accomplished with a subsearch , perhaps a subsearch of a |transaction session startswith="pageType=browse" . ... View more