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
