Column comparison: how to find and filter out differences between columns

Started by rmpf2

I am wondering, is it possible to filter and search for differences between columns? Like a comparison, to find when specific values are not the same.

Example:
Column 1(Logged User Name)  Column 2(Email)
Mike                        [email protected]
Peter                       [email protected]
Jan                         [email protected]
In the second row we can see the difference between 'Peter' and 'Pete'. Any idea how to achieve that? If it is possible...
SoftPerfect Support forum - Andrew avatar image

Re: Column comparison: how to find and filter out differences between columns   31 October 2020, 13:17

Sure, that is possible.
First, create a virtual column that extracts the part before the @ character in email addresses. Let's call it Email Login:

SoftPerfect support forum

Then, use the filter that highlights the rows where the columns do not match:

SoftPerfect support forum
Andrew, that's pretty amazing.

Thank you!

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 ********        **  **     **  **     **  **     ** 
 **    **        **   **   **   **     **  **     ** 
     **          **    ** **    **     **  **     ** 
    **           **     ***     *********  ********* 
   **      **    **    ** **    **     **  **     ** 
   **      **    **   **   **   **     **  **     ** 
   **       ******   **     **  **     **  **     ** 

Message: