[ACTIONS/IMPORTS] When importing use the file name for automatic mapping

Options

Description: As a model builder, I want to be able to use the file name that the user uploads, so that it can pick up automatically a dimension. This can be done when the source system exports files that have dynamic naming based on the selection of dimensions.

 

Example of Enhancement: I’ll know this is successful when I am able to import a file with a name such as "Available_Workforce_Jan-2020" and automatically pick-up the time period "Jan-2020". Another example would be "CoGS_Canada_Jan-2020" and automatically allocate this data to "Canada" for "Jan-2020".

 

Benefit / Impact: This will help with automating the process of importing even more where the source system allows to export file with a specific naming based on selection.

At the moment I either ask the client to add a column in the file which contains that dimension OR the user does a selection before importing OR use a set of actions that based on which button it's pushed automatically selects a dimension.

2
2 votes

New · Last Updated

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!