Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
How to add new colums to a qvd?
Could any one provide example for this
Thank you,
SatishRaj
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
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)
Thank you Suni
Thank you Massimo
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;