HI Team,
I am new to tableau. I want to join 2 tables in Tableau desktop on 2 columns based on 'or' condition.
TABLE1[COL1]=TABLE2[COL1]
OR TABLE1[COL1] = TABLE2[COL2].
Two tables are from two different databases.
Kindly help.
1 answer
Hi @Varsha Shah -
One way is to pivot COL1 and COL2 of TABLE2 first prior to joining.