Connect data?

[#1]

Hi,

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?

Thanks in advance!

/Lina

[#2]

Hi Lina,

If i understood your problem, the problem lies in your data like below.

Think like Table1: KundNy data has "Lina ced" and Table2: KundNy data has "lina Ced". The name is same in both the tables but you are viewing it twice.

If it is the case use Capitalize() function in the script for both the tables.

Ex: Capitalize(KundNy)

Please let me know if it is not the case.

[#3]

Thank you for your input, you have almost got it right but it is not capitals that is tha problem, it is numbers. I have customer names that is:

"Lina Ced"

"Lina Ced     -2423"

which is the same customer. Is there a function that can help me "erase the number and spaces"?

Thank you in advance.

[jpapador]

You could try:

Trim(PurgeChar(FIELDNAME, '1234567890-')) as NewCustomerName

That will take out and numbers and the dash and also trim any leading or trailing spaces.

[#5]

Thanks, but I tried it in list box properties under the sheet expresion, but nothing happend. Should i write the expression somewhere else?

[jpapador · Accepted solution]

Yes in the script.  Please see attached for an example.

[#7]

Thank you so much!

[#8]

One last thing, your expression runs perfect, but my problem now is that the names of the customer is data from two excel columns. How do I get Name to be a "vector" and not just RAD AB and RAD AB  -1215

Table1:

LOAD
        Name,
        Trim(PurgeChar(Name, '1234567890-')) as NewName
Inline [
       Name
       RAD AB

       RAD AB  -1215

];