Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Unique tool enhancement - deal with case sensitive data

Hi team,


I have a set of data that contains functional mapping of cost centers of the organisation. Such mapping is maintained by an administrator in the system and he manages and modifies/add changes.


Administrator does not consider the case sensitivity and sometime may write the same function name in UPPER and Proper case say for example "OPERATIONS" and "Operations"


I need to use such mapping in a workflow where I need to extract unique function names from the mapping.


Since a function has more than one cost centers so there are multiple lines for a function name in the mapping. 


I used Unique tool to do this. But this tool has a limitation that it considers the case sensitivity and reads the same word written in different case type as two unique values.


So in my case the i got two lines for the same function - one in UPPER case i.e. "OPERATIONS" and other with Proper case i.e. "Operations"


In order to tackle this problem, I used formula tool to convert entire text in uniform case type and then applied Unique tool.


Suggestion : I suggest enhancing the Unique tool to give user an option to configure it to consider case sensitivity while selecting unique values from the data.

1 Comment
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes