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

Started by rmpf2

rmpf2

Column comparison: how to find and filter out differences between columns 31 October 2020, 02:57

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                        Mike@somemail.domain
Peter                       Pete@somemail.domain
Jan                         Jan@somemail.domain

In the second row we can see the difference between 'Peter' and 'Pete'. Any idea how to achieve that? If it is possible...

Reply Quote

Andrew

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

Admin
Registered: 15 years ago
Posts: 6 130

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

Reply Quote

rmpf2

Re: Column comparison: how to find and filter out differences between columns 01 November 2020, 04:49

Andrew, that's pretty amazing.

Thank you!

Reply Quote

Print view of this page

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:

Disable BBcode in this message Disable smileys in this message

Help information

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

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

Enter the code:

Message:

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

Reply to this topic

Software Products

Online Store

Help & Support

Download

SoftPerfect