Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm kind of stuck with the tables I'm modelling for a small Qlik Sense application. Maybe there's a way to keep things simple and I'm not seeing it.
I have a table of "Corridors" and "Signals" belonging to the corridor. Note that one signal can belong to more than one corridor:
LOAD * INLINE [ SignalCode,CorridorID 7026001,1 7026001,2 7026002,1 etc.
And I have another table where I define the "approach link" to the Signals, with a column that tells the direction:
Approaches: LOAD * INLINE [ SignalCode, Approach_Dir, link.id 7026001,'E',70752504 7026001,'W',70752004 7026002,'E',70752503 7026002,'W',70752005 ];
Now my problem is that I have some links that are not an approach to any Signal, but that belong to the corridors. If I try to do something like below, I create a circular reference:
Corridor_Links: //Links that belong to each corridor and are not approaches LOAD * INLINE [ CorridorID, link.id 1,70752006 ];
Do you know of any "clean" way to model this tables? What would you recommend?
Thanks much