topic Re: Is it possible to create a batch file in the Qlikview Script in QlikView

Is it possible to create a batch file in the Qlikview Script

rustyfishbones — Fri, 21 Mar 2014 15:36:37 GMT

Hi All,

I have an execute that creates my folder structure as well as running the Extraction.

One of the folders I am creating is to hold my batch files.

Can I use Qlikview to create those batch files and have them moved to the batch files folder I just created

so after I create the BATCHFILES folder, I then want Qlikview to create the .BAT file too

Can this be done?

Regards

Alan

rustyfishbones — Fri, 21 Mar 2014 16:22:55 GMT

Is it possible?

maxgro — Fri, 21 Mar 2014 20:08:41 GMT

is that you want?

DIRECTORY;

Bat:

load 'echo pluto' as col1 AutoGenerate 1;

concatenate (Bat) load 'echo pippo' as col1 AutoGenerate 1;

STORE * from Bat into Bat.bat (txt);

rustyfishbones — Fri, 21 Mar 2014 20:55:26 GMT

it's close,

but here is the correct answer I received from Stephen Redmond

BatFile:

Load

'REM This is a batch file test' As [@echo off]

AutoGenerate(1);

For Each vFile in FileList('c:\temp\Folder1\*.txt')

BatFile:

Load

'MOVE $(vFile) C:\Temp\Folder2' As [@echo off]

AutoGenerate(1);

Next

Store BatFile into c:\temp\test.bat (txt);

Drop Table BatFile;

EXECUTE c:\temp\test.bat;

rustyfishbones — Fri, 21 Mar 2014 20:58:08 GMT

Stephen responded to my request through his blog

check it out it's fantastic

Regards

Alan