Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
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