JOINING ON A RANGE | ALTERYX WEEKLY CHALLENGE #1 | I CAN ALTERYX THAT

Often, joining two data sets is difficult. We can encounter any number of problems. One of the most common issues is that one data set has individual ID values while the other has a range of ID values. 

State

ID State
101
Minnesota
102
Wisconsin
103
Florida
104
Georgia

Region

ID Range Region
101-102
Midwest
103-104
Southeast

We want to join these two tables together so we have ID, State, and Region all in the same data set. But doing this isn’t exactly the most obvious thing in Alteryx.

Watch our YouTube video below to learn how to join on a range.

What is "I CAN ALTERYX THAT"?

I CAN ALTERYX THAT is an ad hoc video series on YouTube created for Tessellation’s Data Coach product. Whenever John Emery or I create some in Alteryx Designer that we think would be helpful for a broader audience, we record and share our development.

We don’t have a scheduled cadence, but follow our Data Coach YouTube channel our our I CAN ALTERYX THAT playlist to be notified when we have more content.

Like what you are reading?

Get articles sent to you when they are posted.
Comments are closed.