topic Table with new column in QlikView

Table with new column

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Table with new column

mdmukramali — Tue, 19 Dec 2017 18:26:40 GMT

Hi,

Simply Add the column like.

'test' as Test

// in the load script.

Re: Table with new column

sunny_talwar — Tue, 19 Dec 2017 18:27:25 GMT

You can just do this

LOAD Name,

address,

amount,

'test' as Test

FROM ...

Re: Table with new column

mdmukramali — Tue, 19 Dec 2017 18:28:31 GMT

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,