Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

use of bridging table to avoid duplication in many to many relationship ?

Hi there,

How to avoid duplicating the tables as there are many to many relationship with bridging table ?

Many to Many relationship Data set - same cost centre

data.PNG

same ward 

 

 

ward.PNG

 

How to use bridge table ?

 

In my qlikview script -

DIM_WARD_CC:
LOAD
TRIM([Cost Centre Description]) as "Cost Centre",
TRIM(Ward) as WARD
FROM
[Ward_CostCentre_Mapping.xlsx]
(ooxml, embedded labels, table is Sheet1) where len(Ward)>0;

DistinctWard:
LOAD
DISTINCT "WARD"
RESIDENT DIM_WARD_CC;


DistinctCC:
LOAD
DISTINCT "Cost Centre"
RESIDENT DIM_WARD_CC;

 

is this correct way? 

The data model looks like -

datamodel.PNG

0 Replies