Join two tables with different dimensions

[#1]

Hello,

i attached a qv-file that shows my problem.

i have two tables and i want to connect them over the dimensions D2 and A2. The problem is that Dimension A2 contains not only charactes - numbers and signs too.

Is there any function to cut the signs and numbers of dimension a2 so that i can join the both tables?

Best regards,

Aylin

[#2]

you can try:

KeepChar( A2 ,'abcdefghijklmnopqrstuvwxyz')

in your loading script

[jvitantonio · Accepted solution]

Done. Please check attached app.

[#4]

Thanks 14,

I didn't know it can be two dimension as an argunemt of keepchar;)

[#5]

Thank you very much qlikuser14!

[#6]

'But know i have different values in Dimension D2 and A2.

With your solution it is now not possible. how can i get the right table, that show in the first line the values of

D1 = 2 and A1 = 1,

second line

D1^= 65, and A1 = 89,

third  liine

D1 = 77 and A2 = 79.