Create new QVD every month.

ashishp — Wed, 17 Aug 2022 13:50:55 GMT

Hi There

We are using monthly refresh.

We want to create new QVD for every month refresh and store old QVD with respective month name.

Thanks in advance,

Re: Create new QVD every month.

Andrei_Cusnir — Thu, 18 Aug 2022 11:25:24 GMT

Hello,

You can add the following script after load statement:

let name = MonthName(Today());

Store TableName into [lib://Location/$(name).qvd](qvd);

This will get the current month, year as name and store a new QVD file.

Output:

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.

topic Re: Create new QVD every month. in Connectivity & Data Prep

Create new QVD every month.

Re: Create new QVD every month.