Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Matching list of numbers from column of min and max numbers ranges

TJ2
7 - Meteor

I have a list of numbers (Master#) that I need to determine if any of them are within this list of min-max numbers and somehow identify a match.

This is just a small sample as the Master# list contains >1000 numbers and the Min Max rows can be >200 different ranges

 

Master# MinMax
71100100 7110010071100108
71100101 7110011071100110
71100102 7110015171100158
71100103 7110020071100212
71100104 7110021471100216
71100105 7110021871100220
71100106 7110022171100221
71100107 7110030071100313
71100108 7110031471100315
71100110 7110035071100351
71100151 7110041971100420
71100152 7110042271100423
71100153 7110043371100433
71100154 7110043571100436

 

 

I think this depiction below can better explain the challenge.

 

TJ2_0-1585321042087.png

 

 

 

Any help on how to accomplish this would be appreciated.

 

Thanks

 

5 REPLIES 5
ydmuley
12 - Quasar
12 - Quasar

Hello @TJ2 

 

Please try this formula.

 

IF [Master#] >= [Min] AND [Master#] <= [Max] THEN "True" ELSE "False" ENDIF

 

ydmuley_0-1585319576514.png

 

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Greg_Murray
12 - Quasar

@TJ2 

 

If I understood you question correctly, I think this might be what you are looking for. 

Greg_Murray_0-1585319791753.png

 

Greg

 

 

TJ2
7 - Meteor

Thanks for the response. In looking at the solution I edited the question in order to clarify the problem.

Greg_Murray
12 - Quasar

@TJ2 

 

I think the solution I posted above meets your adjusted requirements.

 

-Greg

TJ2
7 - Meteor

Thanks. I can work with this.

Labels