In script, you can use function called "Left"
e.g. In 1 table, Customer name = Mike Freeman xyz
In 2 table, Customer name = Mike Freeman
In script, fetch these customers with function
Left(Customer,5) as Customer,
This 5 indicates first 5 alphabets of Customer name.
Since, you will apply this for both tables, same name will get captured in QV while loading.
I hope this can serve purpose.
If not, please share sample data, Excel & QV.