How to Dynamic de-Select fields that all have the same value within the same field?

[arthurmauk]

Hi all, I've got a piece of data that has a lot of fields, but a lot of the fields have the same values within that field (e.g. the value under the Source field is "Risk Register" for all the records since they were all sourced from the Risk Register).

I would like to not waste time looking at those fields, and would prefer to concentrate my time on looking at fields that have more variable values, so I would like to de-Select those fields. How can I do this please? Thanks in advance.

[OllieClarke · Accepted solution]

Hey @arthurmauk this workflow will remove any columns which only have 1 value

Hope that helps,

Ollie