Can I reload a table performing a calculation on 2 fields?

[tomdabek]

Once a qvw is loaded & populated with all the data can i manipulate the tables after the load?

Lets say i have a .qvw file with the table called SALES

SALES contains two fields, quantity and price

Can i add a script element that will 'reload' SALES and create a new field called revenue where revenue = quantity * price  ?

Seems simple but i cannot figure this out.

Thank you

[Anonymous]

noconcatenate

LOAD *,  quantity * price as revenue resident SALES;

drop table SALES;

[Anonymous]

alternatively use preceeding load:

LOAD *,  quantity * price as revenue;

SALES:

LOAD ...;