Hello guys,
So, I have three database about the skills of my team, as shown below, I'm trying to use the merge function on BI (power query) to have a table like this:
| Name | Trainning that the person need | Trainning that person have |
| Augusto | 1 | |
| Augusto | 2 | 2 |
| Augusto | 3 | |
| Augusto | 4 | 4 |
| Augusto | 5 | |
| Augusto | 6 | 6 |
| Augusto | 7 | |
| Augusto | 8 | |
| Augusto | 9 | 9 |
*In the exemples I reduced the number of lines to simplify the explanation, but I have a big data of this.
However every time that I try to performe this, the data of the table look randomic like this:
| Name | Trainning that the person need | Trainning that person have |
| Augusto | 1 | 2 |
| Augusto | 1 | 3 |
| Augusto | 1 | 2 |
| Augusto | 1 | 3 |
| Augusto | 1 | 4 |
| Augusto | 2 | 4 |
| Augusto | 2 | 4 |
| Augusto | 2 | 4 |
| Augusto | 3 | 4 |
| Augusto | 4 | 4 |
| Augusto | 5 | 4 |
| Augusto | 6 | 4 |
| Augusto | 6 | 4 |
| Augusto | 6 | 4 |
| Augusto | 6 | 5 |
| Augusto | 7 | 4 |
| Augusto | 7 | 5 |
| Augusto | 7 | 5 |
| Augusto | 7 | 5 |
| Augusto | 8 | 4 |
| Augusto | 8 | 4 |
| Augusto | 8 | 4 |
| Augusto | 9 | 4 |
| Augusto | 9 | 4 |
| Augusto | 9 | 4 |
| Augusto | 9 | 4 |
| Augusto | 9 | 4 |
----------------------------------------------------------------------------------------------------------------
| Name | Enrollment | Shift | Line |
| Augusto | 1 | 1 | FMD |
| Bruno | 2 | 2 | 3 |
| Caio | 3 | 1 | FMD |
| Jaime | 4 | 3 | FMD |
| Jeosmar | 5 | 3 | 1 |
| Enrollment | Class | Sub-class |
| 2 | IWS | PMCard |
| 4 | IWS | PMCard |
| 5 | IWS | PMCard |
| 2 | PLC | PLC. Beckhoff |
| 4 | Segurança | NR10 |
| 4 | Segurança | Pulsar |
| 4 | Impressoras | Videojet |
| 5 | Segurança | NR10 |
| 5 | Segurança | NR35 |
| 5 | Impressoras | Videojet |
| 2 | Periféricos | SACU |
| 5 | Periféricos | SACU |
| 2 | IT | Chronos |
| 5 | IT | Chronos |
| 2 | Impressoras | TTO |
| 3 | Impressoras | TTO |
| 3 | IWS | DH |
| 2 | Maker | M5 |
| 2 | Packer | FX1 |
| 2 | Buffer | Capricórnio |
| 3 | Maker | GD121P |
| 1 | Maker | GD121 |
| 2 | Maker | GD121 |
| 4 | Maker | GD121 |
| 5 | Maker | GD121 |
| 2 | Maker | GD121A
(Walrus) |
| 3 | Bobineiros | RF-20 |
| 3 | Bobineiros | BOB-M |
| 3 | IWS | IPS |
| 3 | IWS | CL |
| 3 | IWS | CIL |
| 3 | IWS | DH |
| 3 | IWS | MP&S |
| 2 | IWS | Equipment owner |
| 2 | IWS | IWS Básico |
| 5 | Segurança | Pulsar |
| 1 | Segurança | NR10 |
| 2 | Segurança | NR10 |
| 3 | Segurança | NR10 |
| 4 | Segurança | NR10 |
| 5 | Segurança | NR10 |
| 1 | Segurança | NR35 |
| 3 | Segurança | NR35 |
| 4 | Segurança | NR35 |
| 3 | IT | SAP |
| 1 | Filter maker | KDF2ER |
| 3 | Controle de qualidade filtros | MIDAS (Microwave) |
| Line | Class | Sub-class |
| FMD | IWS | Pilar PM |
| FMD | IWS | Pilar AM |
| FMD | IWS | PMCard |
| FMD | IWS | IPS |
| FMD | IWS | UPS |
| FMD | IWS | WPA |
| FMD | IWS | CL |
| FMD | IWS | CIL |
| FMD | IWS | DH |
| FMD | IWS | MP&S |
| FMD | IWS | Equipment owner |
| FMD | IWS | OEE |
| FMD | Segurança | Pulsar |
| FMD | Segurança | NR10 |
| FMD | Segurança | NR35 |
| FMD | IT | CHRONOS |
| FMD | IT | SAP |
| FMD | Filter maker | KDF2 |
| FMD | Filter maker | KDF2ER |
| FMD | Filter maker | KDF3 |
| FMD | Filter maker | DF10 |
| FMD | Filter maker | MULFI |
| FMD | Filter maker | MONTRADE |
| FMD | Filter maker | RESY |
| FMD | Filter buffer | Resy |
| FMD | Filter buffer | Highbay |
| FMD | Emissores | MAGOMAT-M |
| FMD | Emissores | MAGOMAT-80 |
| FMD | Emissores | HCF |
| FMD | Emissores | UNIFLOW |
| FMD | Emissores | FILTROMAT S2 |
| FMD | Emissores | FILTROMAT 3S |
| FMD | Emissores | FILTROMAT 1S |
| FMD | Emissores | DEMATIC WCS |
| FMD | Emissores | DEMATIC SRM |
| FMD | Emissores | FILTROMAT |
| FMD | Emissores | FILTROMAT (AMK) |
| FMD | Kit capsula | Kit capsula hauni |
| FMD | Controle de qualidade filtros | Câmeras Montrade |
| FMD | Controle de qualidade filtros | MIDAS (Microwave) |
Could anyone help me?
