Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Done. Please check attached app.
you can try:
KeepChar( A2 ,'abcdefghijklmnopqrstuvwxyz')
in your loading script
Done. Please check attached app.
Thanks 14,
I didn't know it can be two dimension as an argunemt of keepchar;)
Thank you very much qlikuser14!
'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.