Forum Discussion
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:
6 Replies
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.
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
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.
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.
- 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
