community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Unique Tool Enhancement: Adding "Dynamic or Unknown Fields" Selection

I have need to Unique my data on all fields. However, I do not know all the fields that will be in my data because of a Dynamic Select tool (or in some cases a Cross Tab tool). The Unique tool defaults to having any new fields be unchecked in its configuration. Without finding some work around, I will be unable to schedule this workflow or turn it into an app for use on the Gallery without risking duplication caused by the Unique tool that fails to capture new/different fields that may come through the data.

 

To solve this problem and be consistent with other tools in Alteryx, the following features need to be added to the Unique tool:

  1. The user should be able to check a "Dynamic or Unknown Fields" option that will enable Alteryx to include any new fields in the data as part of the Unique (or any fields that have their names changed).
  2. If a field that was checked in the Unique tool before no longer exists, it should appear yellow (like the missing fields in the Select tool) and produce a warning in the Results window. The option to "Forget all missing fields" will also need to be added.
4 Comments
Alteryx Alumni (Retired)
Status changed to: Under Review

Hi @DultonM,

 

This discussion came up at Inspire Europe and I agree there is a need for updating how the Unique tool works.   We will consider these options for Unique as we look to revamp the individual tools with new and more consistent functionality.

 

In the meantime, one of our developers, @AdamR, quickly put together a macro that accomplishes the Unique functionality that you're looking for.  PM me your email address and I can send you the macro to try out.

 

Thanks,
Ben

Alteryx Partner
Alteryx Partner

I would also like to see a .yxft file (so I can save the field configuration) created for the Unique tool. Then at least if I were aware of what is coming out of the dynamic tools I wouldn't have to worry about losing my settings which has happened on occasion when I am clicking around the workflow and I haven't ran it in a while.

 

Atom

HI @BenG,

 

Can you please send me the macro with "Dynamic or Unknown Fields" option or with same functionality.

 

ashoks@systechusa.com.

 

 

Thanks,

Ashok

Alteryx Partner

@BenG @AdamR if you have the Dynamic Unique macro still somewhere, I'd be highly appreciated if you can send it to me as well 🙂 My email is: ruben,roel@accenture.com

 

Thanks!

Ruben