Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Join two tables with different dimensions

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

1 Solution

Accepted Solutions
jvitantonio
Valued Contributor III

Re: Join two tables with different dimensions

Done. Please check attached app.

5 Replies
Not applicable

Re: Join two tables with different dimensions

you can try:

KeepChar( A2 ,'abcdefghijklmnopqrstuvwxyz')

in your loading script

jvitantonio
Valued Contributor III

Re: Join two tables with different dimensions

Done. Please check attached app.

Not applicable

Re: Join two tables with different dimensions

Thanks 14,

I didn't know it can be two dimension as an argunemt of keepcharSmiley Wink

Not applicable

Re: Join two tables with different dimensions

Thank you very much qlikuser14!

Not applicable

Re: Join two tables with different dimensions

'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.

Community Browser