Problem while creating relationship?

[arunjha]

Hello All,

Recently i am facing a problem while creating relationship between table. It shows an error saying as i mentioned below:

[konstantinos]

Always keep in mind that if you remove duplicates with query is case sensitive while the data model engine is not..meaning Sam , sam is different in PQ but same value for PP engine

[Akahn]

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]

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.

[Seth_C_Bauer]

@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.

[Haegi]

Hi,

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

See an sample below.

Hope it's help you.

[Seth_C_Bauer]

@arunjha I'm guessing the screenshots are just a sample of your data set, because the if it is the entire data set, you should have no problems.

I am running version 2.27.4163.351 - and had no issues building this, in fact the relationship is automatically created. I also tested the removal and add back for the sample set below.

Your RTC Source table can only have a single value for each "event label" - so as an example "Sam" can only show up one time. I'd review your Source data to remove the duplicates you obviously have in there.