Compare Multiple String Fields for all file Rows to identify Rows with differences

valeriemattas

Hello,

I am trying to figure out a way to compare the string data across 10 columns for all rows in my file. We are reviewing a matrix of access permissions which are either "Deny", "Hide" or "Edit." The permissions are listed in the Rows and there is a Column for each User role. (See sample file attached).

Is there a way to identify which rows have differences between columns?

Thanks for your help,

Valerie

Sample Permissions FIle.xlsx

apathetichell

Hi!

I love the Summarize tool's "Count Distinct" feature.  Here's a workflow which transposes the entries grouping by row, then it uses a summarize tool to look for which rows have multiple entries. I added a filter tool at the end to isolate those rows with differing permissions.

Hope this helps!

sum count distinct.yxmd