Forum Discussion
Data modelling
There are 3 tables in my data model. dim_stage, agg_route_stop & dim_route_stage. dim_stage to agg_route_stop one to many relationship(On stage_key column) & dim_stage to dim_route_stage one to many relationship (on stage_key column). agg_route_stop to dim_route_stage many-many relationships. Now I want stage_key column (dim_stage table), tripfrom_tripto column(agg_route_stop table) & distance (dim_route_stage table) in my table visual. But while while dragging these columns in to table visual I am getting error.
1 Tripfrom_tripto have multiple stage_keys & I want the distance b/w these stages(stage_keys) for a particular Tripfrom_tripto
1 Reply
Hi,
Create a Bridge Table b/W agg_route_stop and dim_route and connect with both agg_route_stop and dim_route using that newly created bridge table.
Note :- Bridge table is nothing but a disitinct of key column from any of (agg_route_stop and dim_route).
