Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.