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

[ashmitp869]

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

same ward 

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 -