Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Automated Save As job

Is it possible to create an automated Save As job for my Qlikview file?

Basically what I need is a copy of my file to be saved everyday at 15:00 with this name format stock_report_2012_06_22.qvw

Cheers,

Mem

Tags (5)
1 Solution

Accepted Solutions
Highlighted

Re: Automated Save As job

Hi,

Assuming you don't have Publisher, you can do that using the Windows Scheduler that calls a BATCH file with OS instructions to copy the original file to a new location with that name.

A .BAT file with something like the following should work.

SET DATESTAMP=%DATE:~0,2%_%DATE:~3,2%_%DATE:~6,4%

COPY OriginalFile.qvw Stock_Report_%DATESTAMP%.qvw

Hope that helps.

Miguel

View solution in original post

3 Replies
Highlighted

Re: Automated Save As job

Hi,

Assuming you don't have Publisher, you can do that using the Windows Scheduler that calls a BATCH file with OS instructions to copy the original file to a new location with that name.

A .BAT file with something like the following should work.

SET DATESTAMP=%DATE:~0,2%_%DATE:~3,2%_%DATE:~6,4%

COPY OriginalFile.qvw Stock_Report_%DATESTAMP%.qvw

Hope that helps.

Miguel

View solution in original post

Highlighted
Not applicable

Re: Automated Save As job

worked perfectly, thanks very much!

cheers,

mem

Highlighted
Not applicable

Re: Automated Save As job

Hi Miguel,

I have to publish the Archived QlikView Files to the Server.

How can we do that?

the file names will be different. so we cannot create task for every file.

so how we can do it but not by mounting folder?

can you please help me?