Forum Discussion

WALEED's avatar
WALEED
Advocate II
8 years ago
Solved

Transform Values taken from a Lookup Table

This is a tough. Please help!   I'm trying to change multiple values in multiple fields on a table. I have another table which has the name of fields, old values, and new values.  e.g.   Source T...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

WALEED

 

Here are the steps for Power Query Solution

 

Step #1: select Field Columns in Source Table and unpivot them

 

 

Step 2: Perform a Merge Query using 2 fields each from Source Table and LookUp Table

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    WALEED

     

    You can follow the remaining steps from the Query Editor.

     

    This is the end result.