Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to create a qvw file to move files

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

3 Replies
Anonymous
Not applicable

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

Not applicable

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