Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
community Alteryx IO MyAlteryx
alteryx Community
Search
Knowledge
  • Global Community
  • This Category
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
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 1491 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.