Creating new column by adding or subtracting value in other columns

[#1]

Hi All!!

is it possible to make another column by adding or subtracting other two columns?

for example, let's say by Outer Joining I got three columns col1, col2, col3

Can I make col4 by col1 - col2?

[Gysbert_Wassenaar · Accepted solution]

NewTable:

LOAD

     col1, col2, col1 - col2 as col3

RESIDENT

     OldTable;

DROP TABLE OldTable;