combining two different table sets

[Kendra2276]

The desired result: Combine Table 1 with Table 2
Table 3
County State Zip Unique Tracking Number FIIPS code
Clark WA 98685 xyz121 123
Yacolt WA 98685 xyz122 123
King WA 98685 xyz123 123
Skamania WA 98685 xyz124 123
Hood WA 98684 xyz125 222

I tried to do a join with no results. Tomorrow, I am going to re-try the join but make sure that table 1 and table 2 are both in alphabetical order with regards to County and State.

Essentially, I just need to attach FIIPS to the main data frame.

Attempt at a join
sc<-left_join (Table1, Table2) didnt get the FIPPS code attached

tried to create a column in table 1 called FIIPS
id$FIPPS<-''
sc<-left_join (Table1, Table2) didnt get the FIPPS code attached

If county, state,, zip are the same then why am I unable to keep the unique tracking number and add in the fipps column?

Thanks!

[jrkrideau]

We need a reproducible example (reprex)

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[williaml]

Possibly:

left_join(Table1, Table2, by = c('County', 'State', 'Zip'))

But yes, it would be good if you provide a reproducibe example and also the error that shows up when you try to join.