I tried the above, but still I have some issues. Let me explain (what I missed to do above). What I have: I have 3 different events being generated async. with their corresponding durations. They all share a common Id called "loaderId". see eg. below Event Source LoaderId Duration Page Load 03904756 33.2 Page Load 03904766 23.2 Event Source LoaderId Duration End To End 03904756 33.4 Event Source LoaderId Duration Total Time 03904756 33.7 In the above example, you can see there are 2 events in Page Load but only 1 for the other 2. What I want: When I used join using LoaderId, I get the final output like below. LoaderId "Page Load Time" "End to End Time" "Total Time" 03904756 33.2 33.4 33.7 This eliminates rows from all events where there are no duration values in any of 3 event sources. What Happened with previous Suggestion: When I tried to group by loaderId I see results like below LoaderId "Page Load Time" "End to End Time" "Total Time" 03904756 33.2 33.4 33.7 03904766 23.2 I tried to remove the 2nd row by using len function or isnotnull for durations, but it didn't help. Let me know how I can get the result.
... View more