Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

directory

hi all,

is there a command to delete a directory  using qlikview script?

for ex: after the report runs --at the end the script we should delete that directory

Labels (1)
13 Replies
alexandros17
Partner - Champion III
Partner - Champion III

take a look to "Execute"

Not applicable
Author

Execute is working good for files..folders I tried below... not working

EXECUTE cmd /C rmdir/s C:\Documents\*.* ;

Not applicable
Author

hi all,

any suggestion here?

giakoum
Partner - Master II
Partner - Master II

try this :

EXECUTE cmd /C "rmdir/s C:\Documents\"

giakoum
Partner - Master II
Partner - Master II

/QQuiet mode, do not ask if ok to remove a directory tree with /S.
jonas_rezende
Specialist
Specialist

Hi, benny1409.

Make the following steps below:

  1. Create a folder in your directory of name TESTCOMMUNITY.
  2. Create a bat_Test.bat file name and place within it the following command and save file in c:\
    cd\
    c:
    rd TESTCOMMUNITY


  3. In Script area Qlikview, insert EXECUTE cmd.exe /C C:\bat_Test.bat;
  4. Click Ok;
  5. Click in Menu Settings->User Preferences...
  6. In Security tab, mark Script (Allow Database Write and Execute Statements)
  7. Click Ok;
  8. Reload qvw;

After test successfull, transfer for your app *.qvw.   


Anyway, the file was attached.


Hope this helps!

Not applicable
Author

hi ioannis /Jonas

delete works good

Is their a similar way to move from one folder to another 12122013.xls where all xls files are there within this folder. so the whole folder needs to be moved

for ex: I want to move a folder called

C:/23092015 folder To D:/

so everyday a new folder comes I need to move to 😧 as back up

for ex 23092015

24092015

25092015

jonas_rezende
Specialist
Specialist

Hi, benny1409.

Utilize the same principle. Make one bat file with statement for move xls. Ex.:

cd\

c:\

cd TESTCOMMUNITY

move *.xls c:\<directory desired>

Not forget of execute in Qlikview, before command EXECUTE delete.

Not applicable
Author

hi Jonas,

how can I give a UNC path in the directory for ex: \\servername\..... etc