Join on ranges

[#1]

A version of the join macro which allows to join numeric values with ranges without using brute force.

Behind the scenes, it uses spatial to do so!

User Guide : 

Top entry is the range ( R ), you need to have at least a start and end value for each line

Bottom entry is the value ( V), you need to have one line per value

 

[Maxbfromsc]

Hey Ladarthure, interested in this.
Could you provide an example for how you are utilizing this tool?

I would try to utilize this join tool to match three digit zips to a three digit zip range.

[Ladarthure]

@Maxbfromsc I added a screenshot for easier configuration :)

[Maxbfromsc]

This is amazing, thanks so much!

[robi]

Hi Arthur and thanks

Tested, if 2 fields have the same names .... the V field is prefixed Universe : OK

R:

V:

Result : 

A new macro  : FindReplace with numeric value could be usefull.... ;-)

----------------------------------------------------------------------------------------------------------------------------------
Merci Arthur et bravo

Testé, les champs de noms identiques sont préfixés en Universe : OK

1 idée d'une nouvelle Macro : un FindReplace qui permettrait de jointer sur du numérique ? Merci

Cordialement

[Clifford_Coon]

@Ladarthure - Thanks, what a great method:

In my real world use, I have a number of range definitions that are single number ranges and the macro as-is returns them as unmatched.

I added one "new" section to return the single range matches to the "J" output instead of the "R" output.

This is what I did:

 

[mkalsheikh01]

Very good. Very helpful.

[Bruno_Pelletier]

Here is an alternative using TILES instead of "spatial line vectors".