Forum Discussion
arunjha
10 years agoNew Member
Problem while creating relationship?
Hello All, Recently i am facing a problem while creating relationship between table. It shows an error saying as i mentioned below:
arunjha
10 years agoNew Member
Hi Akahn & Eno,
Can you share the procedure in detail. We have one common filed as Event Lebel with repeated value between two tables and i want to create relationship between those tables and without removing the duplicate value. Is this possible? Please help me.
Anonymous
10 years agoNot applicable
arunjha - sorry didn't see the reply on this. You can use Akhan's advice and create a seperate table with just unique users (events) Then build your model like this:
and you will see that by using the unique user that the aggregates roll up to the unique user from both tables. I just used arbitrary numbers.