Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Introducing Alteryx Marketplace

Easily access verified, supported, and secure Add-Ons.

LEARN MORE
Comments
Maxbfromsc
6 - Meteoroid

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
14 - Magnetar
14 - Magnetar

@Maxbfromsc I added a screenshot for easier configuration :)

Maxbfromsc
6 - Meteoroid

This is amazing, thanks so much!

robi
7 - Meteor

Hi Arthur and thanks

 

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

 

R:

robi_0-1653640180298.png

 

V:

robi_1-1653640240927.png

Result : 

robi_2-1653640516556.png

 

 

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
11 - Bolide

@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:

Join_Range_ccc.jpg

mkalsheikh01
5 - Atom

Very good. Very helpful.

Bruno_Pelletier
5 - Atom

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

 

Join on Ranges.PNG