remove columns where all rows have the same value

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!

Preparation

Accepted answers

Felipe_Ribeir0

Hi @DSH

One way of doing this:

keep.yxmd

OllieClarke

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

All comments

Felipe_Ribeir0

Hi @DSH

One way of doing this:

keep.yxmd

OllieClarke

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'

Hope that helps,

Ollie

DSH

Hi @Felipe_Ribeir0 , @OllieClarke

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

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157