Identical names not matching

[soncoku]

Hey all.
I'm using the Join tool and I'm matching 2 different lists on the name field.

1 input is an excel file

the other input is Google Sheet.

The column type for both is V_WString.

The strings are identical but they do not match.

Any ideas as to why this is happening?

[ChrisTX]

Are your two fields the same Case?  The Alteryx Join tool is case-sensitive.

But in Excel:

f1	f2	Matched?
aa	AA	TRUE

Here is a related Idea, if you'd care to add a Like:  Ensure all tools and functions include a case-sens... - Alteryx Community

Chris