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

Is there possible Create a folder in Dev using Qlikview script

Thu, 26 Feb 2015 15:44:15 GMT

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

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

datanibbler — Thu, 26 Feb 2015 15:53:50 GMT

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

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

luciancotea — Thu, 26 Feb 2015 15:56:42 GMT

Execute cmd.exe /C "mkdir TestFolder";

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

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

Fri, 27 Feb 2015 14:11:59 GMT

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

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

luciancotea — Fri, 27 Feb 2015 14:18:39 GMT

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)";

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

Fri, 27 Feb 2015 14:36:45 GMT

Hi Lucian,

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

Thanks in advance

Vignesh