topic Re: Join two tables with different dimensions in QlikView https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353660#M492378 <HTML><HEAD></HEAD><BODY><P>Thank you very much qlikuser14!</P></BODY></HTML> Tue, 17 Jul 2012 10:39:52 GMT 2012-07-17T10:39:52Z Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353656#M492374 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i attached a qv-file that shows my problem.</P><P>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.</P><P>Is there any function to cut the signs and numbers of dimension a2 so that i can join the both tables?</P><P></P><P>Best regards,</P><P>Aylin</P></BODY></HTML> Tue, 17 Jul 2012 09:11:27 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353656#M492374 2012-07-17T09:11:27Z Re: Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353657#M492375 <HTML><HEAD></HEAD><BODY><P>you can try:</P><P></P><P>KeepChar( <SPAN style="font-style: italic;">A2</SPAN> ,'abcdefghijklmnopqrstuvwxyz')</P><P></P><P>in your loading script</P></BODY></HTML> Tue, 17 Jul 2012 09:32:29 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353657#M492375 2012-07-17T09:32:29Z Re: Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353658#M492376 <HTML><HEAD></HEAD><BODY><P>Done. Please check attached app.</P></BODY></HTML> Tue, 17 Jul 2012 09:50:22 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353658#M492376 jvitantonio 2012-07-17T09:50:22Z Re: Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353659#M492377 <HTML><HEAD></HEAD><BODY><P>Thanks 14,</P><P>I didn't know it can be two dimension as an argunemt of keepchar;)</P></BODY></HTML> Tue, 17 Jul 2012 10:37:10 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353659#M492377 2012-07-17T10:37:10Z Re: Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353660#M492378 <HTML><HEAD></HEAD><BODY><P>Thank you very much qlikuser14!</P></BODY></HTML> Tue, 17 Jul 2012 10:39:52 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353660#M492378 2012-07-17T10:39:52Z Re: Join two tables with different dimensions https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353661#M492379 <HTML><HEAD></HEAD><BODY><P>'But know i have different values in Dimension D2 and A2.</P><P>With your solution it is now not possible. how can i get the right table, that show in the first line the values of </P><P>D1 = 2 and A1 = 1, </P><P>second line</P><P>D1^= 65, and A1 = 89,</P><P> third&nbsp; liine</P><P>D1 = 77 and A2 = 79.</P></BODY></HTML> Tue, 17 Jul 2012 11:36:38 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-dimensions/m-p/353661#M492379 2012-07-17T11:36:38Z