topic Re: Adding Column in QlikView

Adding Column

NavinReddy — Wed, 15 Jan 2014 13:13:10 GMT

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 — Wed, 15 Jan 2014 13:26:01 GMT

Hi guys Help me some one.....

nilesh_gangurde — Wed, 15 Jan 2014 13:28:03 GMT

Can you please elaborate about what exactly you want.

-Nilesh

NavinReddy — Wed, 15 Jan 2014 14:50:22 GMT

Hi Nilesh,

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

Regards,

Niranjan

nilesh_gangurde — Wed, 15 Jan 2014 16:03:22 GMT

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 — Wed, 15 Jan 2014 16:05:39 GMT

LOAD

Field1,

Field2,

Field1 + Field2 as Field3

FROM yourqvd

nizamsha — Wed, 15 Jan 2014 16:23:21 GMT

load * field1+field2 as field3 ;

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

Anonymous — Wed, 15 Jan 2014 16:34:10 GMT

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"

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].
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