im not able to create relationship between two unique colomun.

[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."

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

[gckcmc]

I think you've got duplicate values in "column A"....the numerical ones might be unique, but your table also shows blanks in Column A.  That can be the duplicate issue.  I would filter column A, to remove the blank rows, and also if needed, select the column and remove duplicates before then trying to create the relationships.

[challarajes82]

Thanks for the reply,

But in my case col a value associated with Col b Value. So i cant delete spaces in col A.

Is there any other way 

[gckcmc]

Well you have cases where there is a blank in Column A, which ties to multiple values in Column B.  For example:

40036	8641906
	8724484
	8759290

I'm not sure how you have a relationship for A vs B when A is blank and B has different values.

I would suggest creating unique values for A, which can be done by changing the blanks, or removing the rows which are blank.  That's key to getting your relationships established.  This is why you're getting an error, the system doesn't know what to do with these cases (blank plus multiple column B choices)

[challarajes82]

Yeah, my case little different .

Col A values and Col B values are assigned to each value.

For ex : 

40056

5727812

40026

5824960

These are Emp id 's ..40056 is emp id ohn 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.