5 Replies Latest reply on Apr 30, 2018 8:44 AM by Shinichiro Murakami

    Comparing Fields in Two Data Sources

    David Gabra

      Hello,

       

      I have one long table that holds data on suppliers and employees.

      Is there any way of checking if any of the fields for different rows are the same

       

      Before:

       

       

      Desired Result - This is desired result. 

       

      We will have the reference of all lines that are the same and it will be easy to filter and the last column will be a count, so basically, the higher the number, the more fields that are the same for different rows.

       

       

      This looks demanding for me, but I hope you one you, it will be a possible. It will help so much.

       

      Attached in a twbx, if needed.

       

      Thank you in advance.

       

      David.