Best data model in Qlik sense

[siva_boggarapu]

Hi All,

Please look at the attachment. Three tables Discountcodemap, ReceiptDiscounts and Franconnect form a circular reference.

I want to create composite keys in Discountcodemap.

I want to to create two keys in  Discountcodemap(Discountcode and Alignment_DMA) and it is connected two Franconnect (Alignment_DMA)

This is making me circular reference and I use the statement in my script

Loosen table Discountmap.

But after loading the data it was making two red dotted lines.

How to follow best data mode in this scenario?

[zebhashmi]

Generic keys

[Digvijay_Singh]

Can you remove mapping between receiptheader and FranConnect?

They are connected through StoreID. Even if you remove that mapping, you will have storeID information through your other link. Just a thought!

[YoussefBelloum]

one solution would be to:

join the fields you need from DiscountCodeMap to ReceiptDiscount

and join the fields you need from DiscountCodeMap to FranConnect

rename the common fields to not make a join between ReceiptDiscount and FranConnect