How to reference an input from one data set into another data set without duplicates

[tessaenns]

I have 2 data sets joining together. Data set 1 represents an ACTUAL reflection of what happened and data set 2 represents a PLANNED reflection of what was suppose to happen. 

Data set 1 (ACTUAL reflection)

Data set 2 (PLANNED reflection)

What I need to do is use the data set (planned reflection) as a reference point for data set 1 (actual reflection) so I get something like this...

I have tried joins and appends, but it is multiplying the data, which I want to avoid. Is there a work around?

[Claje · Accepted solution]

Hi,

Are you joining on both Location to Location AND Carrier to Name?

I think that based on the example shown below, this would create no dupes.

[MarqueeCrew · Accepted solution]

Same as Jessie! Join your locations and carrier to name.

Cheers,

Mark

[tessaenns]

I forgot to mention, in the ACTUAL dataset, you can see a location repeating itself. I joined on location and name, but because of that issue where you can see...

Location

1

1

1

2

3

with different names and different PLANNED rates, it still corrects dupes. Ideas?

[MarqueeCrew]

I think so