calling vbscript macros from script editor to load tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a process in vbscript that read a external files and prepare the data to the analysis. That is:

vbscript1: Input_file -> transformations -> output_file (the structure needed to anayze in QV).

I know that I can call vbscript functions to use it in a load script, but I want to execute a whole process (vbscript1) like this from

the script editor, How can I do that?

I want to run the macro and after to use a load statement in script editor to load output_file data in a resident table of QV.

How can i do that?

Is possible that the vbscript load directly in the QV resident table??

Thank in advance

Re: calling vbscript macros from script editor to load tables

swuehl — Sat, 02 Jul 2016 10:42:32 GMT

I don't think so.

But you should be able to ouput the data to a file from your vbscript code.

Then use an EXECUTE statement in your script to run a bash script with your code, resulting in a temp table file on your hard disk.

Read this file in using a LOAD ... FROM ... statement.