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

[rustyfishbones]

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]

Is it possible?

[maxgro]

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 · Accepted solution]

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]

Stephen responded to my request through his blog

Qlik Tips

check it out it's fantastic

Regards

Alan