Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there possible Create a folder in Dev using Qlikview script

Hi Everyone,

     I have multiple excel file in alphabetical order. Requirement is i need to auto generate those excel file in new multiple folder.

i.e AtoE file in single folder and F to J files in a separate folder likewise. I need to do for all the files using Qlikview script. Any Ideas for this?

Thanks in advance,

Vignesh Kumar

5 Replies
datanibbler
Champion
Champion

Hi,

I think QlikView does not really have functions for this - but using the EXECUTE command you can use a command_line and there you can easily create folders.

I don't know the syntax, but I have used them before to delete some temporary qvd_files, so it should be possible.

I just don't know how to pass the information about the letters to the command_line - then you'll just have to create dedicated EXECUTE_statements and put them into an IF THEN clause so you can pass a hard_coded folder_name and create it when is anything to store into that.

HTH

Best regards,

DataNibbler

luciancotea
Specialist
Specialist

Execute cmd.exe /C "mkdir TestFolder";

In the script window, bottom "Settings" tabs, click the "Can Execute external Programs"

Not applicable
Author

Hi Datanibbler and Lucian,

I tried by executing it through batch file to move a excel file from one location to another location.

But am facing problem like if the 'file name' or 'folder name' has space its not working.

Its only fetching the file from the tem table in which we create but not moving or copying the file.

Kindly suggest some idea for this. i referd in CMD.exe

It give if we use "" qotes then the file moves but its doesnt work in qlikview script.

Thanks & Regards,

Vignesh

luciancotea
Specialist
Specialist

This works:

Execute cmd.exe /C "mkdir "Test Folder"";

Use variables to define double quotes and build your string:

LET vQuotes = '"';

Execute cmd.exe /C "mkdir $(vQuotes)Test Folder$(vQuotes)";

Not applicable
Author

Hi Lucian,

Can you help me with an sample qvd file. so that i can refer.

Thanks in advance

Vignesh