Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this
Table1:
load
F1,
F2,
F1&'1'&F2 as F3
sql select * from sourceTable;