Update Unique Tool using the Dynamic Action Tool

[mariyaivanenkiv]

Hi guys, I'm new to Alteryx and I'm trying to create an app where the user can input a file and choose a column, the app will then output their chosen column with just the unique values in it. I'm having trouble with the unique tool not recognising the column from the dynamic select, how can I go about this?

[AshRez]

Try one of these two:

1- when the user select the column, to update the Unique tool to select the same column.

2- You can also use summary that count the select column and filter for anything over 1.

[binuacs · Accepted solution]

@mariyaivanenkiv IF you want only the unique value of the given field then use the summarise tool, The sample workflow is attached

[apathetichell]

@AshRez-> unique tool caches schema information and doesn't allow for new columns to be selectors. @binuacs I'm a fan of this approach.