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!
Solved! Go to 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