Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Folder with Variable Name

Hi

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

1 Reply
Not applicable
Author

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