Forum Discussion

lucadelicio's avatar
lucadelicio
Impactful Individual
2 years ago
Solved

Merge queries

Goodmorning Everybody,

i need your precious help.

I have two tables.
The first one represents the communication and the groups to which it was transmitted.

IdCommunication IdGroup
1 5
1 6
1 7
2 5
2 7
2 8

 

The second represents the users to which group they belong:

IdGroup IdUser
5 1
5 2
5 3
6 4
6 5
6 6
7 7
7 8
7 9
8 10
8 11
8 12

 

What I need, is to know which users the communication was sent to.
So my table result has to be like this:

IdCommunication IdGroup IdUser
1 5 1
1 5 2
1 5 3
1 6 4
1 6 5
1 6 6
1 7 7
1 7 8
1 7 9
2 5 1
2 5 2
2 5 3
2 7 7
2 7 8
2 7 9
2 8 10
2 8 11
2 8 12


It is possible to do it with PowerQuery?

Thank you very much in advance.

Luca

2 Replies