Forum Discussion
Alirezam
Helper V
Helper VReplacing multiple valuse in Query
Hi mates, I have 2 tables. I want to replace one column's values with the second table. According to the photo attached, I want to replace 1 with a, 2 with b, 3 with c, so on. I know I can do it wi...
v-juanli-msft
Community Support
Community SupportHi Alirezam
If the problem is sloved, could you kindly accept it as a solution so to close the case?
If not, please try the method below:
If your data is simple as your screenshot, create a match table, then merge queries in your main table, finally expand the column to get the "Letter" column.
If your data is complex, please show me some examples.
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.