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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Join via non-date range

Meteor

Hi All,

 

I have two datasets - and I need to do a join based on a range. It is important to note that the ranges are in decimals.

 

My dataset looks like this:

2.PNG

 

 

 

 

 

 

 

 

 

 

 

and my output would look like this:

 

1.PNG

 

 

 

 

 

 

I have attached the excel file if this helps. 

 

Any recommendations would be appreciated!

 

Thank you!

 

Bianca

 
Asteroid

It seems to me like you need a summarise rather than a join. I've created and attached a workflow for you that achieves the exact output when compared to what you supplied.

 

 

 
 
Labels