Join using OR

[sxyedur]

Hello,

I was wondering if there is a way to join two tables in a workflow together but have an OR statement of some sort?

My current SQL code follows this logic:

Table1 

Left Join Table2

ON Table1.Field1 = Table2.Field1

left join Table3

ON Table1.Field2 = Table3.Field1 OR Table2.Field2 = Table3.Field2

Thank you!

[Luke_C]

Hi @sxyedur 

There's not a native way to do to this. What you'd probably need to do is something like this:

• 1 join tool on table 1 and table 2
• Join resulting J output to table 3 based on field 1
• Join any fall outs on field 2
• Union the results

[caltang]

If you can provide some sample data, we can show you better via Alteryx @sxyedur