Analytics App File Upload Automation

[Vigneswaran]

Hi, 

I have my input data for 2021 in my folder, now the user needs to work with 2022 data (which is also available in the same folder). 
Can I prompt the user while running the workflow to first select the Financial year, and provide a list of years available in the folder
Upon selecting the 2022 year, the action should change the file path given in the input.

Example: 
My input data file path "C:\Users\vicky01\Desktop\Test\SampleClient\2021\Master File\MappingSheet.xlsx"

After the user selects the year (2022) from list. 
The updated input data file path should be "C:\Users\vicky01\Desktop\Test\SampleClient\2022\Master File\MappingSheet.xlsx"

Just the year should get updated in the input file path

How can I perform this using analytics app!

Thanks in advance!

[FinnCharlton]

@Vigneswaran ,

Here is the start of a workflow that does what you're looking for:

The dropdown will update with the list of years present in your folder. When the user chooses a year, the files will be filtered to only include that years file. You'll need to set up a dynamic input after this filter to actually open the file.

Hope this helps