I have two tables that I need to link together but they don't share enough common key fields so I had to bring in a 3rd table but Qlikview sees this as loops
Given the following 2 tables
Accounting Ledger Table
Batch number (multiple items in batch)
Item Ledger Table
Batch number (many items have same batch #)
I want to get the actual accounting data to go with item transactions. Since accounting is in batches of item, I need to also consider the item. In one table I have item Number in the other Item description, the only way to really link them is to bring in a 3rd table.
However when I link the 3 tables together, I get a warning one or more loops have been detected Qlikview will cut the loops by setting one or more tables as loosely coupled.
I was in the middle of trying the mapping when your answer came in. I did get the mapping to work as suggested above, but your answer sounds simple. I will make a copy of my document and maybe give it a try also that way I can broaden my knowledge.