This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
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:
and my output would look like this:
I have attached the excel file if this helps.
Any recommendations would be appreciated!
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.