Forum Discussion

migueljoa's avatar
migueljoa
Frequent Visitor
5 years ago
Solved

Help with this Powerquery Puzzle!

I have a table with the following columns: [Date] [BalTerm1] [BalTerm2] [BalTerm3] [Rate1] [Rate2] [Rate3]   I want it to look like this: [Date] [Term] [Balance] [Rate]              1           ...
Need Help
  • migueljoa's avatar
    migueljoa
    5 years ago

    Solved it!

     

    1. Unpivot Term Columns
    2. Unpivot Rate Columns
    3. The result will be a matrix that repeats all combinations of Term and Rate
    4. Replace text to match Rate attribute to Term Attribute
    5. Create a column to find attributes that are the same
    6. Remove rows that are not a match
    7. Rename columns properly and remove the new row created.

     

migueljoa's avatar
migueljoa
Frequent Visitor
5 years ago

Solved it!

 

  1. Unpivot Term Columns
  2. Unpivot Rate Columns
  3. The result will be a matrix that repeats all combinations of Term and Rate
  4. Replace text to match Rate attribute to Term Attribute
  5. Create a column to find attributes that are the same
  6. Remove rows that are not a match
  7. Rename columns properly and remove the new row created.