Forum Discussion
New User Power Query full outer join
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
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.
3 Replies
- HotChilli
Community Champion
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.