Forum Discussion
lucadelicio
2 years agoImpactful Individual
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
- ryan_mayuSuper User
- lucadelicioImpactful Individual
There was duplicated data in my dataset so the result was not what i aspected.
Thank you vry much for the support!