How to create a qvw file to move files

[jim_chan]

Hi guys,

i have created a qvw that help me to move files from 1 folder to another folder.

But i am lacking some tables/visuals at the front , that actually can let me see:

- what files you have move from folder A(Original) to destinated folder.

Anyone has any idea , how to create?

I have my qvw file as per attached.

Rgds

Jim

[Anonymous]

Hi, Jim,

I see, I suppose you use the guild for the script here,

As it dropped the only table with "[@echo off]" column, that is why you see no table loaded in QV, if you delete the script below:

Drop Table BatFile;

Then you can see the table.

Zhihong

[#3]

you can use this code:

let path_to='C:\qlikview\DATA\';

For Each vFile in FileList('C:\Folder1\subfolder\*.csv')

  EXECUTE cmd.exe /c move $(vFile) "$(path_to)";

NEXT;

[marcus_sommer]

You could just add another load within your loop maybe below your BatFile-load - I mean something like this:

LogFileMoving:

load '$(vFile)' as Source,'C:\qlikview\DATA\CSV' as Target, now() as Timestamp

autogenerate 1;

and this could you display within a table or other charts.

- Marcus