Why does my Unique Tool get reset/blanked out? I have to re-run my workflow to even use it

[hydrogurl01]

Hi everyone,

For some reason in one of my containers, I have 2 Unique tools. Both for some reason get reset when I open the workflow up or haven't touched it in a while on my screen and essentially forces me to re-run the workflow to get a view of what fields I can do a Unique on. I get an error when running the workflow saying 'At Least One Unique Field Must be Selected' and then when clicking into the tool I get a blank screen with no fields to pick from until I re-run the workflow for it to pickup the fields right before that tool. What is the reason for this? Any way around it? Big time sucker to have to re-run the workflow so much just to re-select my necessary fields and again re-run the workflow.

[atcodedog05]

Hi @hydrogurl01 

This one is a strange issue. I think you should drop a mail to support team support@alteryx.com they might be able to help you.

And once its resolved please do let us know how it got resolved so that its helpful for others.

[Qiu · Accepted solution]

@hydrogurl01 
Just maybe, can you check if you have checked the auto configure?

[hydrogurl01]

@Qiu 

That was it! I don't even recall checking that button - thank you! Is there a performance/optimization trade off by checking/unchecking that?

[atcodedog05]

Thats amazing @Qiu 🙂

Learnt something new 😀

[Qiu]

@hydrogurl01 
Normally, I dont think we can even notice the trade off, unless you have a really huge one.
Thanks for the mark.

[RobertOdera]

Hi, @hydrogurl01 

In addition to @Qiu fantastic insight, have you considered using the Sample Tool instead of the Unique Tool?

IMHO, the Sample Tool might be more performant + might not present the inconvenience you've mentioned.

I hope it works out. Cheers!

[PhaniV]

Disabling auto configuration doesn't fix the issue with unique tool, this is annoying bug in Alteryx

[jc0528]

I think it is a bug the Alteryx team is too lazy to fix. Every time I open the Alteryx, the unique tool has no memory about what we have selected to be unique. You cannot click on the tool or else it will return an error. The only thing you can do is to run the workflow once so the unique tool gains the memory, and "remember" what field it has been selected to unique on. What a design, imagine the workflow taking 30 min + to run every time. What an annoying bug

[PhaniV]

It is weird that I have uncheck the Disable Auto configuration for the Unique tool configuration to work. If you are experiencing this issue, try both options check and uncheck Disable Auto Configuration in Advanced User settings