remove columns where all rows have the same value

[DSH]

Dear Alteryx exprerts, 

I have the following table: 

ID	parameter_1	parameter_2	parameter_3
#1	2	5	4
#2	2	8	4
#3	2	7	4

My goals is to remove all the columns that have identical values for all rows (in this example, only "ID" and "parameter_2" will remain). Number of rows is dynamic (from 2 to 100s). 

I will be grateful for all suggestions, 

Thanks! 

[Felipe_Ribeir0 · Accepted solution]

Hi @DSH 

One way of doing this:

[OllieClarke · Accepted solution]

Just a small amendment to @Felipe_Ribeir0's solution:

The Field Summary tool will output the contents of a browse tool as data. You can filter to where

[Name]='Uniques'
AND
[Value]='1'

This will just show the fields which have only 1 value. The process thenceforth is identical.
The field summary tool is more performant than using the transpose/summarize combo though so if you have larger datasets, it can be twice as fast (based on some testing I just did)

Hope that helps,

Ollie

[DSH]

Hi @Felipe_Ribeir0 , @OllieClarke 

thank you very much for your help - this works perfectly!