Create Folder with Variable Name

Wed, 25 Aug 2010 15:27:45 GMT

I often use variables when I store files as qvd and it works fine.

For exemple:

Let now = left (today(),7);

store field1 from table1 into Folder\Filename$(now).qvd (qvd);

But, how do you create a new folder/directory with a variable name defined as say, today's date, in the store into statment?

This won't work for me:

Let now = left (today(),7)

store field1 from table1 into Folder\$(now)\Filename.qvd (qvd);

Any ideas?

/Kristofer

Wed, 25 Aug 2010 20:25:09 GMT

Hi,

try

LET now=LEFT(NOW(),7);
let path='c:\';

Let cmd='cmd.exe /c md $(path)$(now)';

EXECUTE $(cmd) ;

Assume that should match your needs.

Best regards

Michael

topic Create Folder with Variable Name in QlikView