New User Power Query full outer join

[pkoel-asb]

Hello All,

  I am using Power BI Desktop. I select the option to Transform my data and I am brought into Power BI's Power Query editor. I have two files that have no relationship between them. I want to join the two files togather using a full outer join. When I try to use the Merge Queries, it forcese me to slect a column to join the table upon. There is no common column between them. All I want is every record in File 1 joined to every record in File 2. Something similar to the following:\

Select *

from File1

FULL OUTER JOIN(File2);

How do I accomplish htat?

Cheers!

Peter

[HotChilli · Accepted solution]

I think you want a cross-join.

There are at least a couple of ways to do it. One is :

Add a column to the first table like this

= table2

You can then expand the column.  Give me a shout if that's not what's required.

[pkoel-asb]

I found it! I figured out what you were trying to tell me. YES, it works well! thank you!

[pkoel-asb]

Hello,

  Thank you for your reply. I can not find a Cross-join function in Power BI, but does sound like the task I need to complete. How do I cross join two tables into one?

Cheers,

Peter