FIELD?

[#1]

HOW TO ADD AN EXTRA FIELD TO AN EXISTING TABLE?

[anbu1984 · Accepted solution]

T1:

Load *,'NewField' As NewField Resident Table;

[its_anandrjs]

Hi,

There are many ways a

1. A field based on current field

Load

Field1

If(Field1='A',Field1) as NewField

From LOcation

2. By any resident load

A:

Load * From Location;

join

Load ID,1 as Newfield resident A;

Regards

Anand

[#4]

thanks bro

[#5]

pls close this thread

[ashfaq_haseeb]

Hi,

Try like this

Load *,

'Flag' As NewField FromTable;

Regards

ASHFAQ