We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
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?
Thank you Sharad! very helpful.
So it looks like you just have to get creative with multiple join tools instead of Alteryx having the functionality to be more specific in one join tool.
Pretty much Jcdaniels, unless one can go outside 'In-Db' tab where whole range of tools are available to handle SQL joins.
I haven't used those much, hoping some expert can help us both here.