Forum Discussion
Expand columns doesn't work after Merging queries
This might be a long shot, but sometimes the issue is simpler than it looks.
Does any of the columns that you are trying to join have trailing spaces?
Try to trim the columns or transform them using Text.Start and check if this resolves the issue that you're having.
Hello Jimmy801
The only thing I can see is that on one query the key-column is created out of 13 characters
each Text.Start([CodePDM],8) & "-" & Text.Start([Fournisseur],4)),
Unless I'm mistaken, I'm not joining the other table with that column but with the column "ERPCode".
This column, key PDM-SITE, is the one I want to expand at the end.
and on the other query is a complex split of SplitbyPosition {0,1}, applying a change to the second result and reunion afterwards.
I do these transformations because I have a column "SKU" in the table "PLM_PRODUCT_SAMPLE" which is sometimes finishing by a letter. If there is one, I have to remove it in the column "SKU sans taille" to get the "ERPCode". Finally, I want to join the "SKU sans taille" column of the "HPs" table to the "ERPCode" column of the "PLM_PRODUCT_SAMPLE" table.
I know it's a weird transformation haha but it works.
In summary, I have :
The PLM_PRODUCT_SAMPLE table :
| ERPCode | key PDM-SITE | ... |
| 1111 | 0000275-S005 | |
| 2222 | 0006204-T004 | |
| 3333 | 0006662-T004 | |
| 4444 | 0007083-T004 |
The HPs table :
| SKU sans taille | ... | ... |
| 1111 | ||
| 1111 | ||
| 2222 | ||
| 4444 |
And I want to have the HPs table like that :
| SKU sans taille | key PDM-SITE | ... |
| 1111 | 0000275-S005 | |
| 1111 | 0000275-S005 | |
| 2222 | 0006204-T004 | |
| 4444 | 0007083-T004 |
This might be a long shot, but sometimes the issue is simpler than it looks.
Does any of the columns that you are trying to join have trailing spaces?
Try to trim the columns or transform them using Text.Start and check if this resolves the issue that you're having.
I noticed this in my solution. What fixed the issue for me was I was trying to use a dataverse lookup column and filtered down to just the display column. It kept going null at the end of all steps. After having both the column and display column, the value no longer reverted to null.
Hope this helps.
