I am totally new to QV and would really appreciate som help.
I load QV with data only from excel. I have loaded two different documents but can not create a proper connection between them. In the both documents I have a column with customers. I have tried to name the columns the same name and then I get the connection but in the list of customers the same customers appers twice if they are in the both columns. It looks like the customers name is spelled the same way, but could it be this way if it not EXACTLY the same spelled or how can I manage this?
When I changed the names of the customer to exactly the same I got it to work! My problem is that I can not manually change the name of 1000 customers. Is it possible to match the data in two columns that are nearly the same as:
