adding a new column to an exisiting qvd

[#1]

I have a qvd of data that I complied.  In that QVD I have 3 different calculations where I save them as new columns ( mg, grams,mg/kg).

Next I created a new table name and loaded loaded that qvd, and summed each of the three values sum(grams) + sum(mg)+(mg/kg) and  saved it to a new column named totalGrams

I loaded from resident table and grouped by 3 distinct columns.

I have 6 qvds and would like to be able to create a new column for the total grams

Is there a way I can add that new column to the qvd?

[#2]

You create the QVD with the STORE command

Your QVD will contain only ONE table

When you export the table, you may export the whole table or only some fields (that you can rename by the way).

So, you need to overwrite the QVD: you load it into a table, you modify the table (add column), you export the table (STORE) into the existing QVD by overwritting it

Fabrice