Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Compare two fields to populate a new column

I want to do a simple thing... I want to compare two columns on my report.  If they're the same, I want a new column that says "Yes". (I'm trying to see if comments were entered by an employee or h...
  • Anonymous's avatar
    Anonymous
    4 years ago

    I very much appreciate the assistance from users on this forum!  I found that the solution for my situation was that I needed to do more in Power Query, rather than expecting to do column comparisons in the service.

     

    I first did a 'merge queries', bringing the two userid fields into one merged table.  From there, I added a custom column using an IF statement, populating my new column with data from the existing 'comments' column only if the two userIDs were different.  If they were the same, I put "remove" into the new column, instead of the comments.  Then, in a next step, I filtered rows and removed all rows containing the string "remove".

     

    I've got to remember that Power Query is where all the action is.

     

    Many thanks!