Forum Discussion
Eqa33
Dec 03, 2022Brass Contributor
How to match and assign a word to a letter in a cell
Hi There, I have a column of product numbers, within each number is one letter that represents the type of product it is. How do I marry that letter up to a description from another list so that I ...
- Dec 04, 2022
Eqa33 You missed the most important part and that is that you need to extract the one Letter from the code first. You are now trying to merge the full product code in the Sales table with the category code in the Category table. Obviously, that's not going to return any match.
I've added the step that extracts the code and changed the merge query. It works now.
Eqa33
Brass Contributor
Thanks very much it works well now. I'm still not sure what step I missed. Could you explain it to me in simple language. Thank you once again
Riny_van_Eekelen
Dec 04, 2022Platinum Contributor
Eqa33 The last step of the 2022 Sales SOH query creates a custom column that takes the text from Column1 and removes any dot "." or number from "0" to "9", thus leaving only the single letter.
Now, in the Source step of the Merge1 query you select Custom and Code as the matching columns.
- Eqa33Dec 05, 2022Brass ContributorOk, I see know. I never would have thought to or known how to, enter that formula to seperate the Code Letters from the Product numbers. Thanks very much. I'm teaching myself Power Query. it's very powerful but also quite complex. Thanks for your help once again. Fantastic.