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

[mceleavey]

Hi @valeriemattas ,

Do you mean those that don't have 100% "Deny", for example, but have a mix across columns?

M.

[valeriemattas]

@mceleavey Yes, exactly!

[apathetichell · Accepted solution]

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!

[valeriemattas]

@apathetichell  Perfect, this will do it. Thanks!!

[mceleavey · Accepted solution]

Hi @valeriemattas ,

Workflow attached!

[valeriemattas]

Thank you!! @mceleavey 

[mceleavey]