Forum Discussion
Merging two unrelated tables
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
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
thanks loads, makes perfect sense
ta
Lee
3) Select the columns to display
4) Select and merge the columns
5) And you have the result:
..if you want you can delete the "index colum".
#Good Coding To Everyone#
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?
