Hi. Newbie here.
I have one data set with values and another data set with minimum/maximum ranges. I'd like to do a join to append some data if the value falls within the range.
Think of this as similar to one table of student test scores and another table that contains letter grades assigned to score ranges:
Score
54
92
85
67
72
Letter min max
A 90 100
B 80 89
C 70 79
D 60 69
F 0 59
How do you do a conditional join to result in:
Score Letter
54 F
92 A
85 B
67 D
72 C
Thanks for your guidance.
(Note that an Append Fields cartesian join will result in 1.4 million records! Not sure if that's something my PC can handle)
Solved! Go to Solution.
Actually, 1.4 million records wasn't a problem at all. I used an Append Fields with the necessary columns from both sets of data, then a filter to choose the values that were "in range".
Worked great!