Table with new column

[everest226]

hi i have a chart which has data in 3 column , now the requirement to add a new column which has TEST in column.i need to add expression which will add test column with test type data

Table i have is

Name ,  address,  amount,

sam ,,, Texas, 501

Steve,  Cal, 201

etc

Added column that i want is ( test)

Name ,  address,  amount, Test

sam ,,, Texas, 501, test

Steve,  Cal, 201, test

etc

[mdmukramali]

Hi,

Simply Add the column like.

'test' as Test

// in the load script.

[sunny_talwar]

You can just do this

LOAD Name,

    address,

    amount,

    'test' as Test

FROM ...

[mdmukramali]

Hi,

Load *,

'test' as Test

inline

[

Name , address, amount

sam,Texas, 501

Steve, Cal, 201

];

or in the script.

in the load statement

'test' as Test,