[Data Management] Is there a way to dynamically name the export file based on the run year?
Summary:
Hi everyone,
We are extracting data from our Planning application for an external PowerBI dashboard using the "Data Export to File" target application type. Because we must run each year individually instead of multiple years at once, we would like to dynamically name the output file ("Download File Name" in the below screenshot) based on the year specified when running the integration. Is this possible, either directly in the Download File Name field, or via a groovy rule?
Additionally, is there a way to export multiple years worth of data without the data getting jumbled? Ideally, we would be able to generate a single extract, but when I attempt to run the integration for multiple years, the data is incorrect. Doing this would eliminate the need for dynamic file naming. This is something that I've seen happen for a long time, even on-prem.