This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
How to use bridge table ?
In my qlikview script -
DIM_WARD_CC:LOADTRIM([Cost Centre Description]) as "Cost Centre",TRIM(Ward) as WARDFROM[Ward_CostCentre_Mapping.xlsx](ooxml, embedded labels, table is Sheet1) where len(Ward)>0;
DistinctWard:LOADDISTINCT "WARD"RESIDENT DIM_WARD_CC;
DistinctCC:LOADDISTINCT "Cost Centre"RESIDENT DIM_WARD_CC;
is this correct way?
The data model looks like -