Forum Discussion
Solved
Merge two columns into one table
I have two tables
| Location |
| A |
| B |
| C |
| D |
| E |
| F |
| G |
and
| Type |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
I want to join the above in power query to get the resulting table. Each instance of first table joined with each instance of second table.
| Location | Type |
| A | 1 |
| A | 2 |
| A | 3 |
| A | 4 |
| A | 5 |
| A | 6 |
| A | 7 |
| B | 1 |
| B | 2 |
| B | 3 |
| B | 4 |
| B | 5 |
| B | 6 |
| B | 7 |
| C | 1 |
| C | 2 |
| C | 3 |
| C | 4 |
| C | 5 |
| C | 6 |
| C | 7 |
Result Table = CROSSJOIN(Table1,Table2)
5 Replies
Result Table = CROSSJOIN(Table1,Table2)
create new table and then put the previouse formula with respect to requirements
HI prashanth0626 ,
You can achieve this in Power Query Editor in Power BI. Refer this simple document on combining/merging your 2 tables:
Thanks,
Pragati
Pragati11 i do not have any common fields between the two. I tried all the combinations of merge queries but doesnt give me the required output.
Hi prashanth0626 ,
Apologies I missed that part. There is an existing thread for your scenario on the forum:
Thanks,
Pragati
