Data Quality - Define Business rule joining Multiple Tables/ Columns

Arun7april — Sat, 16 Nov 2024 00:21:38 GMT

I would like to define business rule, by joining multiple tables. I have join Tables with two key columns.

Join condition works as below

Table1 join Table2 on (Table1.col1=Table2.col1)

join Table1 on (Table1.col2=Table2.col2)

Instead of

Table1 join Table2 on (Table1.col1=Table2.col1 and

Table1.col2=Table2.col2

)

because of that am getting error message as " Exception: SQL compilation error:

duplicate alias '

Table1

' "

topic Data Quality - Define Business rule joining Multiple Tables/ Columns in Data Quality