Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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
Esteemed Contributor

Re: Is there possible Create a folder in Dev using Qlikview script

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
Valued Contributor

Re: Is there possible Create a folder in Dev using Qlikview script

Execute cmd.exe /C "mkdir TestFolder";

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

Not applicable

Re: Is there possible Create a folder in Dev using Qlikview script

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
Valued Contributor

Re: Is there possible Create a folder in Dev using Qlikview script

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

Re: Is there possible Create a folder in Dev using Qlikview script

Hi Lucian,

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

Thanks in advance

Vignesh