I've often wondered, however, how to create more complex SQL joins in Alteryx.
inner join B
on (A.production_type = B.production_type
and a.year = 2014)
(A.Homeowner_type = B.Homeowner_type
and a.year =2013)
Because of my client's complex business rules, I often times find myself having to create fairly sophisticated join rules.
Any thoughts on how to do this in Alteryx?