You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

[Data Management] Is there a way to dynamically name the export file based on the run year?

Accepted answer
21
Views
4
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!