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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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