Alteryx: Are joins case sensitive?

Question ID: 109582
0
0

For example, will ‘marketing’ from one input join with ‘MARKETING’ from another input or not? If not, what is a quick work around to get them to join properly?

Marked as spam
Posted by (Questions: 7, Answers: 0)
Asked on June 5, 2020 1:40 pm
6 views
Answers
1
Private answer

This seems to be a popular question around here recently!

 

The join tool in Alteryx IS case sensitive. In the example you provided 'marketing' and 'MARKETING' would not join. See the attached images for examples of what will and wouldn't join. To reiterate, only data points with the same spelling, case, and leading and trailing spaces will join.

 

Hope that helps!

Attachments:
Marked as spam
Posted by (Questions: 0, Answers: 7)
Answered on June 5, 2020 2:31 pm