topic Re: How can I do this join? in QlikView

topic Re: How can I do this join? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-do-this-join/m-p/446767#M166659 <HTML><HEAD></HEAD><BODY><P>Try reading your A and B fields in using text() function:</P><P></P><P>LOAD </P><P>     text(A) as A,</P><P>     text(B) as B,</P><P>     text(A) & text(B) as C,</P><P>...</P></BODY></HTML> Mon, 18 Feb 2013 17:17:05 GMT swuehl 2013-02-18T17:17:05Z How can I do this join? https://community.qlik.com/t5/QlikView/How-can-I-do-this-join/m-p/446766#M166658 <HTML><HEAD></HEAD><BODY><P>Hi, I have to join two fields value like this:</P><P></P><P>A = 1234</P><P>B = 0567</P><P></P><P>C = A&B</P><P></P><P>The result must be C = 12340567 and actually I´m receiving 1234567</P></BODY></HTML> Mon, 18 Feb 2013 17:04:47 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-this-join/m-p/446766#M166658 rcandeo 2013-02-18T17:04:47Z Re: How can I do this join? https://community.qlik.com/t5/QlikView/How-can-I-do-this-join/m-p/446767#M166659 <HTML><HEAD></HEAD><BODY><P>Try reading your A and B fields in using text() function:</P><P></P><P>LOAD </P><P>     text(A) as A,</P><P>     text(B) as B,</P><P>     text(A) & text(B) as C,</P><P>...</P></BODY></HTML> Mon, 18 Feb 2013 17:17:05 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-this-join/m-p/446767#M166659 swuehl 2013-02-18T17:17:05Z