Forum Discussion

jp2050's avatar
jp2050
Frequent Visitor
4 years ago
Solved

Combining Multiple Tables Using a Unique ID Present in All Tables

Hi All,   I need to combine four separate tables, all of them being loaded into BI as excel data source files, into one table on a unique ID present in all tables. Table1 is the “master table” with...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    use the merge query capability... data from table1&2 merged to create Temp2, then merge Temp2 & table 3... and so on.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

use the merge query capability... data from table1&2 merged to create Temp2, then merge Temp2 & table 3... and so on.

  • jp2050's avatar
    jp2050
    Frequent Visitor
    4 years ago

    Thank you!