Skip to Content
0

How to attain when there is no heirarchy

May 04, 2017 at 12:48 PM

44

avatar image

With the above 2 queries how can I attain the resulting table?

NOTICE! The parent event id and event id are at two different levels, what I'm calling a hierarchy.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters May 05, 2017 at 08:24 AM
0

Hi,

try

  1. merge the two queries on event ID and Parent event ID
  2. create detail variable det_clinical event key based on the merged dimension
  3. create table: det_clinical event key - clinical event key - event tag
  4. set break on det_clinical event key

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded