building relationships between two worksheets

I recently watched a video that showed how to combine two worksheets together with a relationship, so that you could create a pivot table using the data from both sheets. The error I am getting is the " both columns contains duplicate values" message but it does not make since. On the video I watched they combined the two worksheets using a column on each sheet that had the same header and the same data. I checked and the two columns are almost identical with multiple shared values and duplicate data. When I try to combine them it works fine, but on my workbook I get the error message. Is there something simple I am not seeing? A formatting issue or something?

Originally Posted by AliGW

Which columns? There are no explanatory notes in the workbook and there's nothing in the Relationships dialog.

The two columns I want to use are either shift or date since they are shared between the two worksheets.

The end goal is to have a dashboard that can take all the data and display it without a ton of calculation pages. The data is vast though with multiple metrics being recorded. It's warehouse shift data.

So you have
on this date, Tom worked from x to z, in that time he did jobs 1,2,3 and 4, during those jobs he faced the following issues, 7,6,5,and 4, so today his performance was "blank".
times that by 30 people per shift, two shifts a day, one on the weekend, and then be able to look at the report either from a whole, shift, department, or individual bases, as well as daily, weekly, or monthly.
right now I individualy create the reports I need with formulas and vba but the calculation times and having to reference all the worksheets and workbooks that hold the individual data can eat a lot of time and is not efficient. I thought buy "combining" all the worksheets and creating a single pivot table from the combined data I can filter as needed, and it wouldn't take so long or take up so much room.