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.
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. :)
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.