Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
I have a question the qlikview has the possibility from a script to copy folder files to another (windows copy paste)
Hello,
Here you go
Step 1 - enable script can execute external programs via "Edit script > Settings tab", screenshot below
Step 2 - Allow database write and execute statements in script via "Settings > User Preferences > Security tab", screenshot below
Step 3 - Create script line as below. You will need to update highlighted bit though. In my example
C:\temp\*.txt (Source files path)
C:\temp\Archive (Target folder path)
Step 4 - reload!
Give this a whirl and let me know how you get on.
Warm regards,
Nish
You can use the VB Script File System Object (FSO)
I am a beginner with qlikview, you can explain to me more
Hello,
Here you go
Step 1 - enable script can execute external programs via "Edit script > Settings tab", screenshot below
Step 2 - Allow database write and execute statements in script via "Settings > User Preferences > Security tab", screenshot below
Step 3 - Create script line as below. You will need to update highlighted bit though. In my example
C:\temp\*.txt (Source files path)
C:\temp\Archive (Target folder path)
Step 4 - reload!
Give this a whirl and let me know how you get on.
Warm regards,
Nish
Hi Souad,
Yes, you can use copy paste from one QVW File script to one more Qvw File,
but make sure the datasource place is same.
Regards
Sathish
Which file type you trying to copy ? and what should be the output format ?
if its a CSV to CSV,Excel ,TXT
TXT to TXT ,Excel ,CSV,TXT
Excel to Excel,CSV ,TXT
then without VB its possible ..
Good morning avinash i used
DIRECTORY;
t: load rand() AutoGenerate 100;
EXECUTE cmd.exe /C move /Y .\QVD\*.qvd .\QVD_OLD ;
store t into .\QVD\t.qvd (qvd);
Hello nishant
thank y So C an i Uses repetitive loop as for, while ...
For example, I want to save the folder names of a path in array and then I loop on that variable
thank y very helpful doc