Skip to Content
0
Former Member
Mar 14, 2014 at 09:00 PM

Solving loops

42 Views

Hi All,

I have a large universe. I made all the joins and everything seems fine. I am stuck at a loop and not sure how do I solve it. Not good at context so need a right way if this needs to solved by context.

five tables forming a loop: 1. Session joined to sample

2. Sample joined to Result

3. Result joined to A

4. A joined to Exposure

5. Exposure joined to session

Initially I made an alias of A as A2 and joined it to exposure and it resolved my loop. But in the report I pull fileds from table A, exposure and Result. So the values from A and Result return correct data but as I pull the filed from exposure in the report it gives duplicate results.(more than what is expected). So I assume there should be a join betwwen A and Exposure but it results in loop. How do I solve this so that these three tables are connected and gives right results. I am using fields from all 5 tables in the report. How will I solve it if I have to use context?

Thanks,

N