Adding Column

[NavinReddy]

Hi All,

How to add one column in while loading data into data source

could some one help me ,where can i add ,how can i do that

Thanks in Advance

Niranjan

[NavinReddy]

Hi guys Help me some one.....

[nilesh_gangurde]

Can you please elaborate about what exactly you want.

-Nilesh

[NavinReddy]

Hi Nilesh,

while loading data into data source i need to add one column into top of the table

Regards,

Niranjan

[nilesh_gangurde]

you can add the column like this:

1)  From Qvd:

Load *,'Test' as TestField

From Source_OF_FILE;

2) From DataBase:

Load *,'Test' as TestField;

Sql Select * From TableName;

Hope this will Help.

-Nilesh

[Clever_Anjos]

LOAD

     Field1,

    Field2,

    Field1 + Field2 as Field3

FROM yourqvd

[nizamsha]

load * field1+field2 as field3 ;

load field1,field2 , field2-field as field4 from qvd;

[Anonymous]

Are you talking Column (field) or Row (record)?

"while loading data into data source i need to add one column into top of the table"

1. If you need an extra Column, do as the other suggested by adding a constant, a value from function or transforming one or more existing fields as [New Column Name].
2. If you need an extra Record in the top, consider concatenating your "real" table with a 1 record table from an Inline Load statement or a "First 1 Load a, b, c From..." or alike with same field names.

/Nicolai