Discussion board where members can get started with Qlik Sense.
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?
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!
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