Case insensitive option while joining two data sets

[Paridhi_Agrawal]

hi team,

Currently the join tool doesn't have option to join the data irrespective of its case sensitivity. this causes issues while doing the analysis.

This tool is widely being taking as a replacement of Excel Vlookup formula (which is also case insensitive),so can we have the similar functionality for Join tool also?

We can have an option like a radio button or checkbox to select if we want to have case insensitivity while joining.

Thanks

[haraldharders]

Same should be done to Filter tool, for instance. In all cases of string comparisons, it should be explicitly chosen whether it is intended to be done case-sensitively or case-insensitively.

[AshRez]

It was suggested on 2017, and Alteryx team tagged it as "coming soon" in 2017. here

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Case-insensitive-join/idi-p/54124

7 years and counting, maybe we can get this feature after another 70 years. 😜