hi,
i have 2 tables which i need to match by name but the match is not 100% and the names are in both tables.
I specifically investigated those names that did not give me the match and they have a different length in both tables.
The ones that match have the same length .I pulled a few of the names that don't give me a match from both tables and seems like they are bad in on the datasets The first table would show me an output such as name="Anna Smith",the other table breaks the output in 2 lines name='Anna
Smith'
and they have different length . I thought it was a space issue, so i tried compress ,STRIP,trim... u name it but nothing worked.
Any solution that would fix this issue,anyone please?
PS.If i go back to the excel files these 2 datasets are created of and re-enter those names manually and re run everything it matches perfectly but don't think that would be a solution on a long term 🙂
Thanks
... View more