How to create a Complex Multi-Join b/w more than two tables in a multi-sourced Relational Universe?

[JYOUSAF]

Scenario:

A complex multi-join in a multi sourced relational universe is as follows:

DS1.Table1.Col1=DS2.Table1.Col1 or
DS1.Table1.Col2=DS2.Table1.Col1 or
DS1.Table1.Col3=DS2.Table1.Col1 or
DS1.Table1.Col3=DS2.Table1.Col1

After making some changes in the backend, Col1,2,3 and 4 from Data Source (DS) 1 have been split and are part of different tables. How do I re-create the above join with the new DS1 fields coming from 4 different tables.

Ideally I want to do the following: 

DS1.Table1.Col1=DS2.Table1.Col1 or
DS1.Table2.Col1=DS2.Table1.Col1 or
DS1.Table3.Col1=DS2.Table1.Col1 or
DS1.Table4.Col1=DS2.Table1.Col1

IDT only lets you create multi joins if the fields are coming from two tables.

Is it possible to create the above joins individually and then somehow combine them with the "or" operator.

Its important to note that the DS1 fields were text fields while new DS1 fields are now master data fields.

Thank you for your inputs. 

[amitrathi239]

Hi,

Define the join  first between two table.

DS1.Table1.Col1=DS2.Table1.Col1

In the expression window of join put the others joins and check if Join validation is ok or not.

I have tested with putting extra join from different tables and it is  validating.

Don't know how it will work in the reporting.

May be you can test this.

Amit