topic Re: Remove all data After run VBScript in QlikView

Remove all data After run VBScript

marco_almeida — Mon, 20 Jan 2014 18:58:05 GMT

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

Re: Remove all data After run VBScript

Mon, 20 Jan 2014 20:36:44 GMT

Hi Marco ,

I believe, you don't need a Macro to store the table data into CSV. You can store the table data csv into by using STORE command like below:

STORE TABLENAME into TABLENAME.csv (txt) ;

If you want to improve your reload time, please implement Incremental load. Please go through the below link for reference.

Incremental Load

Re: Remove all data After run VBScript

marco_almeida — Tue, 21 Jan 2014 02:08:57 GMT

Hello dathu.qv,

thanks for this tip. but i guess my problem is other.

After run script my "calculated tables" are updated. Succeeding, run macro for exporting this table in csv file.

My problem is clear all data after run this macro.

See you later!

Re: Remove all data After run VBScript

Tue, 21 Jan 2014 02:23:26 GMT

I believe, you can add the Clear All option at the end of the Macro script.?

Are you executing the Macro in the script or Post Reload trigger ?

Please add the "Clear All" action on the Post Reload trigger so it will clear all the selections.

Re: Remove all data After run VBScript

marco_almeida — Tue, 21 Jan 2014 12:46:00 GMT

Hi....

Actually, i need to drop all tables after macro...Is the same if i open qvw without data..

Re: Remove all data After run VBScript

Clever_Anjos — Tue, 21 Jan 2014 12:50:53 GMT

Why don´t just do this?

Store yourtable into file.csv(txt);

drop table yourtable;

Re: Remove all data After run VBScript

marco_almeida — Tue, 21 Jan 2014 13:00:39 GMT

Hi Clever....

Because my table is a chart (straight table)..

I need to export this table calculated after running the script, so I used macro.

Is there another way to do this?

Re: Remove all data After run VBScript

Anonymous — Tue, 21 Jan 2014 13:44:06 GMT

I am not sure if it is possible to do this as I don't think you can go back into the script to do a drop table.

As I understand you want to complete a reload then export a straight table (with all the calculations made) and then trigger a drop table from the script. How much data do you need, do you need to load all the data into the .qvw or is it possible to only load the latest data for example last week or month?

Re: Remove all data After run VBScript

marco_almeida — Tue, 21 Jan 2014 13:56:10 GMT

Hello Nills...

that's right...

I reload ever 1 month... But my qvws contains approximately 1GB.. so i need clean then after macro...

but if don't have other way, i'll continue using this method.

Re: Remove all data After run VBScript

Tue, 21 Jan 2014 14:01:25 GMT

Hi Marco, How much calculations are doing in the straight table.

I believe all these calculations will be done in the script level and make one required table by using join or concatenate.

Re: Remove all data After run VBScript

marco_almeida — Tue, 21 Jan 2014 14:03:51 GMT

Hey dathu....

Have 10 expressions... =/

Re: Remove all data After run VBScript

Anonymous — Tue, 21 Jan 2014 14:06:11 GMT

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.

Re: Remove all data After run VBScript

Tue, 21 Jan 2014 14:11:38 GMT

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 ..