Create relationship with duplicate values

[challarajes82]

Table 1, Table 2 and Table 3. Table 1 Col A values are there in Table 2 Col D & Table 1 Col B values are there in Table 3 Col F. While creating relationship from Table 1 Col A to Table 2 Col D it through an error as " You cant create relationship b/w these two columns because one of the columns must have unique values."

40056

5727812

These are Emp id 's ..40056 is the emp id of Mr. John at x location and 5727812 is the emp id of Mr. John at y location.

If there is a case like 

5844808

Mr. Peter is there only y location he doesn't have any presence in x location.

I need to figure out respective timesheet hours for each location. Because of duplicate values (spaces in Col A) we are not able to create relationships. Is there any way to create a relationship without disturbing null values in Col A.

Col A	Col B
40056	5727812
40026	5824960
	5844808
40020	6682456
40070	7748300
40141	8579674
40116	8579958
40069	8641880
40006	8641881
	8641883
40034	8641885
40083	8641890
40023	8641896
40126	8641900
40133	8641902
40096	8641903
40036	8641906
	8724484
	8759290
40172	8927885
40179	9075208
40177	9103880
40148	9248492
40015	9413296
40191	9539589
40190	9603935
40131	9607819
40286	9819773
40157	9953113
40043	9985248
40206	10135515
40207	10283765
40031	10312927
	10385152
40101	10390129
40007	10430151
	10494417
	10504100
40230	10838291
	10935299
40228	11048208
40243	11434183
40237	11545951
40232	11558252
40242	11592590
40249	11667068
40009	11791433
40106	11795195
	11813937
	11820039
40241	11838266
40047	11905631
40256	11916950
40029	11950228
40259	12003626
40134	12027900
40261	12081304
40075	12134235
40264	12268980
	12378898
40267	12451986
40030	12496831
40280	12540564
40281	12543419
40279	12548239
40282	12579915
40119	12677895
40284	12724499
40104	12747173

[Icey]

Hi @challarajes82 , 

Can you give me a sample of Col D? I can't reproduce your question for lack of it. And have you tried Many-to-Many relationship?

Best Regards,

Icey

[challarajes82]

Sorry for the late response. I haven't rued many to many.

 Below are three tables, one is Client loc data and another one is offshore location data and combined information data. I would like to check the discrepancy in hours at each location. so I'm trying to create a relationship with "combined table" col "Emp id -OL" to "Offshore location" col "Emp id -OL" &  "combined table" col "Emp id -CL" to "Client  location" col "Emp id -CL". while creating this its throwing an error stating that " you cant create relationship".

Combined table		Client Location		Offshore Location
Table 1		Table 2		Table 3
Emp ID-OL	EMP ID - CL	Name		EMP ID - CL	Name	hours		Emp ID-OL	Name	hours
40056	5727812	John		5727812	John	40		40056	John	54
40026	5824960	Pat		5824960	Pat	40		40026	Pat	40
	5844808	John1		5844808	John1	0		40020	Pat1	36
40020	6682456	Pat1		6682456	Pat1	40		40070	Nick	35
40070	7748300	Nick		7748300	Nick	40		40141	Sam	40
40141	8579674	Sam		8579674	Sam	27		40116	Ram	40
40116	8579958	Ram		8579958	Ram	28		40069	chrsty	40
40069	8641880	chrsty		8641880	chesty	44		40006	Carrie	0
40006	8641881	Carrie		8641881	Carrie	0		40034	Nick2	36
	8641883	Kirsten		8641883	Kirsten	40		40083	Sam1	40
40034	8641885	Nick2		8641885	Nick2	40		40023	Ram1	40
40083	8641890	Sam1		8641890	Sam1	40		40126	chrsty1	35
40023	8641896	Ram1		8641896	Ram1	40		40133	Carrie2	42
40126	8641900	chrsty1		8641900	chrsty1	40		40096	kisrsten1	36
40133	8641902	Carrie2		8641902	Carrie2	42		40036	Nick1	40
40096	8641903	kisrsten1		8641903	kisrsten1	36
40036	8641906	Nick1		8641906	Nick1	36

[Icey]

Hi @challarajes82 ,

I'm sorry to response late. Based on my test, you can only create 'Many-to-Many' relationship between "combined table" and "Offshore location".

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.