Help me spot the loop

[#1]

I have an association loop in my structure that I need help finding. The problem occurs when I add the "Item Category Code 2" field association in the Discounts table. I'm brand new to Qlikview and I DID NOT create this structure, so please don't judge

[shree909]

Hi ,

Its associating  to the discount table becoz  the discount table has item category code 2 ,

try to rename the fieldname  .

Qlikivew will join or asssociate ir the field names are similar.. this is the qv default behaviour..

if u dont want to assoicaite try to  rename the field names.

[#3]

Problem is that I need both associations on the Discounts table.

[shree909]

Hi,

Why dont u join both the discounts and  "Item Category Code 2 and make as one table.

Disocunt:

load * fromt Discounts table

Join(Discount)

Load  * form  "Item Category Code 2

This will create a one table with Discount

with all the fieldnames from  discount and "Item Category Code 2

Thanks

[#5]

Sorry, Item Category Code 2 is a field name, not a table.

[#6]

Nevermind, I see the loop. I just have to figure out how to set a composite key of Customer Number and Item Category Code 2 that come from different tables.