How to identify the mismatch in two different file & if there's a chance to make the same

[abardaje]

Can some help me on how to identify or what tools should I use for the mismatching and after identifying it then will use the Name column from Diamond file or better yet put some comment that due to mismatch from Ruby vs. Diamond file instead.

[IraWatt]

Hey @abardaje,

Would you be able to give an example final dataset your looking for? Using a join Tool you can easily compare rows and apply a formula to compare them:

Are you always comparing the data on the same row of both files?

Thanks,

Ira

[abardaje]

Let's say we need to identify from 209 data from Ruby system vs 6000 data from Diamond system. I think your workflow is correct and  but I believe Alteryx is a case sensitive so if the Ruby Name is all caps lock while the diamond name is a small letter which is mismatch as well. 

[IraWatt · Accepted solution]

@abardaje You can use the CompareDictionary function to compare two strings with case being sensitive: A case sensitive string compare function - Alteryx Community

Here is an example:

[abardaje]

Thank you! :)

[IraWatt]

No worries @abardaje have a good week 😄

[abardaje]

Just wanted to ask again in a different scenario on how to identify the mismatch ( ie. case sensitive, double spacing, additional character)  only using joint tool  (if not, other tool/s that can identify the mismatch of the data) using my latest dataset?