LAE

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

Originally posted by: a_vaitsos

Hello everyone,

Does anyone know if there is a node available that would perform a �lookup� but instead of checking for exact match would correlative ranges of data?

Take the following example:
Input A:


A-number A- Charging
4223 NULL

Input B:

Start Finish Charging
4200 4300 4250

The �lookup� node I am looking for would check if A-number is within the range of [Start, Finish] and if that is the case would set the Charging value in A-Charging
A-number A- Charging
4223 4250

Thanks in advance,

Alex

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

Originally posted by: rboccuzzi

There isn't currently a single node that does a "Ranged Lookup" as you state above. We do have that request and will be building it in the future. Until then, there are other ways or tools you can assemble to solve this problem, in a variety of ways. None of them are obviously as easy as the single "Ranged Lookup" mentioned above, but could work in various circumstances. I have created an example of a Ranged Lookup node using the LAL Fuzzy X-Ref node (Found in the Enhanced Analytics Pack, you will need to install this).

I made a few assumptions about your case above, to make this work more efficiently. Things like, I assume the range is going to be around 100 or less, so the Exact Match and MaxRange params would need to be tweaked if this is not the case.

I hope this gives you something to start with, and provides an example of something that could be done with the Fuzzy Matching node.

Cheers
Rich
Attachments:
RangeLookup.brg

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

Originally posted by: a_vaitsos

Thanks a lot!

Alex