Forum Discussion

Lee_Mather's avatar
Lee_Mather
Regular Visitor
10 years ago
Solved

Merging two unrelated tables

Is it possible to merge two unrelated tables together   Say for instance I have a Date table, with one column and three rows   Date 1-Jan-15 1-Feb-15 1-Mar-15   The I also have a Names table...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hello Lee_Mather

     

    Yes you can do this in the Query Modeler, but you'll have to modifiy the structure of the tables in order to create a surrogate key" to mege the table.

     

    In the table, you add a new column (SK for example) with the value "1" for all the record.

     

    You do the same with the other table, and now you can merge the two queries, based on this fake relationship. Don't forget to check the relationship type with "full external" and it should be ok.

     

    Sébasttien

Anonymous's avatar
Anonymous
Not applicable
10 years ago

5) And you have the result:

..if you want you can delete the "index colum".

 

#Good Coding To Everyone#

ameliarosaline's avatar
ameliarosaline
Frequent Visitor
9 years ago

I have a similar issue when I created index columns for two of my tables to which I want to create a relationship, but in my case since I used DirectQuery, It says that the resulted query is not supported with Direct Query.

What would be the best workaround for this?