I have a feeling this is an easy one, but I am new to Power Query and not sure how to accomplish the following...
I have a table that contains various lists of codes:
I have a second table that contains the corresponding value of each code:
Using Power Query, how can I replace each code in Table1 with its corresponding value from Table2?
The expected result would be as follows:
I have a table that contains various lists of codes:
| TABLE1 |
| CODES |
| A,B,C,D |
| B,D |
I have a second table that contains the corresponding value of each code:
| TABLE2 | |
| CODE | VALUE |
| A | ValueA |
| B | ValueB |
| C | ValueC |
| D | ValueD |
Using Power Query, how can I replace each code in Table1 with its corresponding value from Table2?
The expected result would be as follows:
| RESULT |
| CODES |
| ValueA, ValueB, ValueC, ValueD |
| ValueB, ValueD |
