LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: the1don

I have a data set with values in it 81, 90, 93, 92, 84, 56
I have a second data set with ranges grade low, grade high grade
60 69 D
70 79 C
80 89 B
90 99 A
100 100 A+

I was trying to use a lookup node.

Any suggestions?

Thank you

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

You can do a cartesian join here. Note that I have added a 0-59 range. Also note that if scores fall outside of 0-100, it gets dropped.

You could also use a 'Band by Strata' node here. The only "tricky" thing is that the stratas start from -01 and end on -00 (instead of -00 to -09), so I adjusted the scores by one before banding.
Attachments:
GradeLookup.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: joyzhang

As it is in version 5, I could not open with v6. Could you please provide some dumpscreen on it? Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gmullin

Here's the same graph saved in v5.1.

GradeLookup_v51.brg