community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Joining on 2 fields

Asteroid

Okay....newbie here - please be gentle......

 

I know it is something obvious.

One file has every county in the U.S. - with some info.

Other file has SOME counties in the U.S. - with other info.

 

I want to join these together - but need to do it based on County name AND state (considering there are counties with the same name in multiple states.)

I picked up that the fields all have to be the same (string) - and I believe I solved for that.

THEN - I learned that joining fields have to be the same case - and I think I did that too.

BUT.......I am only getting a handful of matches.

 

I should have around 1900 matches

 

Ultimately......I want to see unique columns from both inputs - for ALL counties - knowing some fields will be null.

 

 

Alteryx Partner

Hello @CorCor 

 

Welcome to the Alteryx Community!

 

I cant access your excel sheets as they are pointed to a local file on your machine. You can usually copy and paste selected records as seen in the screenshot below, and right click anywhere on the white canvas and paste, and it will create a text input tool with the data you copied.

 

In your case, it sounds like you want to do a left join. So you want to keep all the data on the left, and add on extra data on the right. Im not sure which of your files have more data, but it may well be a right join. I have attached your workflow which has been updated with a union tool after the join tool. 

 

Hope this helps!

 

- Andrew

 

 

Asteroid

Thank you - I will give a try.

 

But sorry you wrote: "as seen in the screenshot below," - was that referring to the pasted workflow?

Alteryx Partner

Woops I have a tendency to do that sometimes.

 

This is the screenshot I was referring to 

 

Copy.png

Asteroid

That did it!

 

Thanks!

Labels