Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to do an "In-between" lookup


Hello all. I'm stuck on a problem, and hoping someone can help me out. I have a large csv file that I am trying to join to an xlsx. In the xlsx I have an ID number. In the csv I have a lower range of id numbers in one column, and an upper range of id numbers in the next column. I need to join the files where the xlsx id is in between the csv lower and upper columns. For example:

csvLowerNum   csvUpperNum   xlsxId
1             10            5    

Any ideas?


@Nismodr there are a number of different ways to accomplish this. Can you possibly provide either the source files or a sample of the source files? That's the best way to get the simplest solution for you.

Alteryx Certified Partner
Alteryx Certified Partner

@Nismodr take a look at the 1st weekly challenge and some of the responses here.


It's basically the same problem as what you have identified.




Awesome, I should be able to figure it out the rest of the way from here. Thanks!