How can I do this join?

[rcandeo]

Hi, I have to join two fields value like this:

A = 1234

B = 0567

C = A&B

The result must be C = 12340567 and actually I´m receiving 1234567

[swuehl · Accepted solution]

Try reading your A and B fields in using text() function:

LOAD

     text(A) as A,

     text(B) as B,

     text(A) & text(B) as C,

...