Forum Discussion

arunjha's avatar
arunjha
New Member
10 years ago

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:
Need Help
Akahn's avatar
Akahn
Advocate IV
10 years ago

I can't see your whole dataset, but at a glance this looks like a many to many issue. One possible solution is to create a table to tie these together. It would have to have a list of unique event labels and would have one to many relationships with RTC Source and RTC User Type

  • arunjha's avatar
    arunjha
    New Member
    10 years ago

    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's avatar
      Anonymous
      Not applicable
      10 years ago

      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:

      1.JPG

      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.

      2.JPG

    • Haegi's avatar
      Haegi
      Advocate V
      10 years ago

      Hi,

       

      Can you tell us what's advanced options are configured please ?

      See an sample below.

       

      Capture2.PNG

       

      Hope it's help you.