ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Advanced Join
Macros Uploaded by on 12-20-2021 Downloaded 1600 times
  • Macros
  • Prep and Blend
    • Download
    Post Comment

    Description

    Advanced Join adds a few functions over and above the Join and Join Multiple tools, namely: right join, left join, and cross join. You can also apply a filtering condition within the tool. Check out the accompanying blog.

    Attachments
    Advanced+Join.yxzp
    Comments
    Maxbfromsc
    6 - Meteoroid
    ‎04-12-2022 01:31 PM

    This helped fix a major project I was working on in joining against three digit Zip code ranges.
    Bumping this Macro and thanks for the help!

    jeanettevaladez
    5 - Atom
    ‎05-16-2022 12:42 PM

    Is there a tutorial on how to use this macro with examples?

    NeilR
    Alteryx Alumni (Retired)
    ‎06-10-2022 10:15 AM

    @jeanettevaladez  yes there are examples attached to the blog: https://community.alteryx.com/t5/Engine-Works-Blog/Advanced-Join-Macro/ba-p/2355

     

    0 Likes
    amir0606
    6 - Meteoroid
    ‎08-23-2023 05:06 AM

    how install ?  

    hilo
    5 - Atom
    ‎10-20-2023 07:31 AM

    I have Alteryx Designer and I would like to add Advanced Join.  How do you obtain it and add it to your tools menu?

    ldwagner
    7 - Meteor
    ‎10-30-2023 11:22 AM

    @hilo  - there is a link to it in the 2nd paragraph of the attached

     

    Advanced Join: value from one file is between, > or < a value from another file (alteryx.com)

     

    You can download and then it will show up as Join In-DB in the search field

     
    0 Likes
    Ahlis
    5 - Atom
    ‎01-30-2024 05:36 AM

    I'm trying also to install the Advanced Join tool and I'm following the instructions on how to install custom tools in Alteryx. 
    https://help.alteryx.com/current/en/server/install/install-custom-tools.html#idm45936843729072

     

    However I can not seem to find "YXI" file in any of the downloaded packages here. I've opened the file I downloaded in Alteryx and it seems to contain a normal workflow.

     

    It's my first time install a custom tool so I guess I'm missing something that will become obvious once I learn it. :)

    0 Likes
    Ahlis
    5 - Atom
    ‎02-05-2024 07:20 AM

    Answering my own comment here but I was able to find it eventually. I had missed the key information in Idwagner's post about it being found as "Join In-DB" inside of Alteryx. 

    I kept searching for a tool called "Advanced join".

     

    One think I could add to any other newbie like me that comes a long is that this tool doesn't seem to work for normal workflows, it doesn't connect. You have to use something called "In-Datebase" tools. I've yet to explore those. In my scenario I wanted to connect it to normal workflow containing formulas, filters etc.