1 matched record is missing after INNER JOIN

hal_dal

Hi,

I am trying to join two tables based on an identifier,

however, after comparing the manual steps with the steps done in Alteryx, seems like 1 record is missing and it should have been matched.

I have tried using the cleansing tool before joining to see if there could be whitespaces but that doesn't seem to be the issue.

I'm not too sure why it's missing in the inner join and cannot think of any other possibilities?

Thank you!

neilgallen

Depending on the confidentiality of the data, it's always best to share a sample so we can likely diagnose what's going on.

Outside of that, it's possible to check the case of the data.The joins are case sensitive.