How to add new colums to a qvd?

[#1]

Hi Friends,

How to add new colums to a qvd?

Could any one provide example for this

Thank you,

SatishRaj

[sunny_talwar]

I guess create a new qvw and load your qvd in it and add the new column to it and store it back on top of your existing qvd.

TempTable:

LOAD ID,

          NAME,

          ADDRESS,

          MARK,

          'A' as NewField //This is the new field you want to create

FROM source.qvd (qvd);

STORE TempTable into source.qvd (qvd);

DROP Table TempTable;

The new source qvd should have a new column NewField with A for all rows.

I hope this will help.

Best,

Sunny

[maxgro]

there isn't any update qvd function

so you have to

- read the qvd file and add the column

- store the qvd with the same name (overwrite)

[#4]

Thank you Suni

[#5]

Thank you Massimo

[qlikviewwizard]

SatishRaj‌

You can create new column like this as well.

TempTable:

LOAD Autonumber(ID&NAME) as Key,

          ID,

          NAME,

          ADDRESS,

          MARK,

          'A' as NewField //This is the new field you want to create

FROM source.qvd (qvd);

STORE TempTable into source.qvd (qvd);

DROP Table TempTable;