how to add a column to an existing labeled table

[ali_hijazi]

Hello

suppose I got the following script

Table1:

load

     F1,

     F2

sql select * from sourceTable;

....

now at some point of the script I need to add a new column to Table1 which is the concatenation between F1 and F2

now what I'm doing is the following:

TempTable:

load F1,F2, F1 & '|' & F2

resident Table1;

drop table Table1

Table1:

load * resident TempTable;

drop table TempTable;

is there another faster way?

[SunilChauhan]

try this

Table1:

load

     F1,

     F2,

F1&'1'&F2 as F3

sql select * from sourceTable;