Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Execute cmd.exe /C "mkdir TestFolder";
In the script window, bottom "Settings" tabs, click the "Can Execute external Programs"
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
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)";
Hi Lucian,
Can you help me with an sample qvd file. so that i can refer.
Thanks in advance
Vignesh