Please consider implementing a consistent case-sensitive option for all tools and functions.
To compare string values, including case-sensitivity: This post had a good description of the challenge, but the post has been archived:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/IF-equation-ignoring-case-BUG/m-p/4170...
For all the time I've used Alteryx, I thought that IF "test" = "TEST" would evaluate to false. Today I realised that isn't the case and I was surprised. I'm very surprised that "equals" performs like it does.
A few existing Ideas request case-sensitivity for individual tools:
Case insensitive option while joining two data sets
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Case-insensitive-option-while-joinin...
Unique tool enhancement - deal with case sensitive data
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Unique-tool-enhancement-deal-with-ca...
This new Idea requests system-wide consideration for case-sensitivity, for all tools and functions.
Current state:
These tools and functions are case-sensitive:
- Tool: Join
- Tool: Tile
- Function: FindString
- Functions: MD5_ASCII, MD5_UNICODE, MD5_UTF8
These tools and functions are NOT case-sensitive:
- Tool: Unique
- Function: CompareDictionary
These tools and functions can be either case-sensitive or NOT case-sensitive, depending on the options used:
- Function: Contains
- Function: EndsWith
- Function: StartsWith
- Functions: REGEX_Match, REGEX_Replace, REGEX_CountMatches
Current Challenges:
How do we easily identify Lower Case, Upper Case, Mixed Case?
How do we easily compare strings for equality, using case sensitivity?
Request:
Ensure all tools and functions include an option to ignore or consider Case
Create new functions for IsUpperCase, IsLowerCase, IsMixedCase
Create a new function for IsEqual, with an option to ignore or consider Case
See attached workflow, which
- uses REGEX_Match to create 3 new fields: IsUpperCase, IsLowerCase, IsMixedCase
- creates a field [Flag: Original value IsEqual, case-sensitive], to compare strings for equality, using case sensitivity
Identify and Compare Strings for Case Sensitivity.yxmd
