join issue

[Anonymous]

i have 2 tables.

1.head Count

2.spend

head count:

[Job Posting Title],

     [Worker: Worker Supervisor],

     [Worker: Worker Supervisor] as [Hiring Manager],

     Worker,

     [Worker ID],

     Status,

     [Start Date],

     [End Date],

"Current Bill Rate [ST/Hr]",

     [Physical Location of Worker],

     [Worker Closed Date],

     [Cumulative Committed Spend],

     [Total Spend]

Spend:

     Worker,

     [Worker ID],

     [Job Posting Title],

     [Worker Status],

     [Worker: Worker Supervisor],

     [Worker Start Date],

     [Worker End Date],

     [Invoice Submit Date],

     [Invoice Amount],

     "Bill Rate [ST/Hr]",

     "Bill Rate [OT/Hr]"

I want join these two tables.

worker Id is not primary key, frequency its showing 2 for @some id's

Worker Name also not primary key ,frequency its showing 2 for some Workers

how to proceed further,any idea would be greately appreciated.

[manojkulkarni]

I don't see any issue with this, still you can join with WorkerID. If you upload some sample data , then it will provide clear picture of data.

[alexandros17]

I think there are not real problems because for each worker you can have more that one expense

[robert_mika]

If worker or worker Id is not primary Key.

Try

Worker&WorkerId as Key

in both tables

[Anonymous]

Hi Please find the sample application

Thanks

[Anonymous]

Hi  Alessandro ,Robert

can u please review my sample application and provide me your suggestion

Thanks in advance

[robert_mika]

As Allesandro pointed there can be multiple instances foe each employee to example this:

You can either comment out the fields that bring you double values or not load them or find out which Supervisor is the correct one

[Kushal_Chawda]

Provide test data also