Combine multiple Tables into one

[Chanise89]

Hi All,

I am hoping someone could help me as I have been recking my brain trying to figure this out!

I have 5 Tables that were pulled in from two different sources (Denodo and Oracle). My goal is to combine these 5 tables together and lets just say we call it KPI Metrics. Once they are combined, I need to build a relationship with the KPI Metric table with two other seperate tables. 

What is the easiest way to accomplish this, if any.

Thank you in advance

[serpiva64]

Hi,

without mock data it is difficult to help you

[Chanise89]

Yes. So the 5 tables in the box are the ones that I need to combine in one table. These table come from 2 sources - Denodo ODBC and Oracle.