Hi again @jon1302 
I just finished responding to your other question, and again stumbled upon another one of yours lol
just kidding
I checked this one too…
You are using data table join here. But it is not going to work because in data table join activity, it looks for an exact match in values.
In one dt, your have Test Ltd and in the other you have Test *. So it is not an exact match. However, we can still do this using string manipulation. Split the string “Test " from the "” character and get what’s onto its left. and then check whether it contains in the other data table value. This is exactly I have done in my attached workflow…
Check it out…
Test.xaml (9.8 KB)
This will work for you!!