Forum Discussion
Solved
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 ...
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.
