Concatination of columns

[#1]

Hi All,

I need to concatenate two columns(say A and B).

As in make another field(say C) which displays both A and B in horizantal allignment

Please let me know the solution(s).

Thanks in advance

[#2 · Accepted solution]

hi

try

A & B as newfield

[maxgro]

in script

load

     A,

     B,

     A & ' ' & B as C,

     ......

from

     ....

[ashfaq_haseeb]

Hi

try

A & '_' & B as C,

Regards

ASHFAQ

[#5]

in script

load

     A,

     B,

     A & ' ' & B as C,

     ......

from

     ....

[#6]

Load A,

         B,

         A & '-'& B as new Field

from

table name;

[#7]

Hello Depak,

you can add the script like this

TableName:

Load fieldA & fieldB as fieldC

from datasource;

Regards

Charitha.