Skip to Content

How to attain when there is no heirarchy

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 05, 2017 at 08:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded