Forum Discussion
How to match and assign a word to a letter in a cell
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 Upload the file please. I need to see the Merge step. What you are merging and how. Did you extract the letter code in any of the other queries, by the way?
Riny_van_Eekelen Tell me if this is what you want to see ,please.
- Ok, 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.
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.
- 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
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.
