Remove all data After run VBScript

[marco_almeida]

Hello guys ...

everything okay?

Could reply my question?

It is this: every day I run the script to load information from my database. After the end of the run, I use a macro (using vbscript) to extract a table (which I created) to csv and finalized qvw.

My big problem is that the data is saved in qvw, leaving it heavy for a next run.

I wonder if I have to remove all information after running the macro ...

Thanks to all: D

[marco_almeida]

Hey dathu....

Have 10 expressions... =/

[Anonymous]

Ok, what I was thinking is if you need more than 1 month of data? If not then you could just load last full month or something similar so that your .qvw only contains max 1 month of data.

[#4]

Hi Maco , that should not be a problem.

You can calculate all these expressions in the script level and join to required table dimensions

Please post your script and expressions so I will help you in the script level ?

Please post sample data that would be a great ..