How to auto select the new columns into the existing Unique tool in alteryx

Question

Hi All,

We have a workflow which gets data from a file on daily basis, and we have Unique tool in place which has all columns selected in it to avoid any duplicates. But we have a chance of getting new columns added to the source file, because of which the data is going to the D output in the unique tool. Is there any way we can auto select all the columns in unique tool if a new column is added on the source file?

BrandonB · Accepted Answer

Hi @Aparanjith

Here is a solution from another member on the community, @danilang

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unique-tool-with-Dynamic-or-Unknown-Options/m-p/460524/highlight/true#M90228