How do we add new colomn in script

[Janitha]

Hi,

How do we add new columns in existed table in script , give me solution on this

[vinieme12]

As below , add any new fields or calculated fields to the LOAD statement

Tablename:

Load 

Field1

, field2

, field3 

, Field1+ field2 as newfield 

From xyzdataset;