Although there probably is a work-around, doing a join and then filtering on the condition is not the same as doing a multi-conditional join.
For example let's say I have 2 tables:
And let say I wanted a left join only on VAR and if DATE is in between Date1 and Date2. If I did it in SQL
SELECT * FROM TBL2 LEFT JOIN TLB1 ON TBL1.VAR = TBL2.VAR AND TBL2.DATE BETWEEN TBL1.Date1 AND TBL1.Date2
I would expect:
But when you do it in Alteryx with a join and then a filter, it joins on Var = B, but then the filter to see if DATE is in between Date1 and Date2 will eliminate that row so that your result is:
The biggest issue with this Alteryx way of doing things is that it will eliminate all the rows where one of the conditions meet, but not the other[s]. Maybe there is a work around here, but it'll be messy, and I feel like multiple condition joins is something Alteryx definitely should add to the next build.