Quick Filter

Question

Hi is there a way to quickly filter all the unique values in one column without manually creating a filter tool for each

this is what Im doing. but I cannot guarantee that this picks all of it.

One solution I can think of is using Output tool, and save each file using "take file name from field" , but I wish to edit it more in alteryx before saving the file.

RaphaelSilva · Answer

Seems like you are pooling all records from the same column [F2], so the solution @aatalai mentioned will return the values you want.
Outputting using "take file name from field" will generate multiple files/sheets, one for each unique record on that field.

If none of this helps you, could you please explain what should look like the output you are looking for?

aatalai · Answer

@Luqman could you use sumamrise group by? Or use the Unique tool