Hi Everyone,
I have a scenario where I need to have the freedom to select any folder in which it contains the multiple files in each of them in a specific path but the folder selection is random(User Dependent).
Like:
The folder is created monthly and weekly basis at the specified path but the user needs the freedom to select any month's or week's folder and the multiple files within.
So I tried a combination of the Text box ( to take input of the week or month value from the user)with formula tool to create the path but I am still stuck in updating the month or week value in the formula on a random basis(we cant use DateMonthfunction).
Solved! Go to Solution.
Here are my assumptions,
1. You are dealing with excel files
2. They all have the same consistent schema
In theory, you can have all the files in a single directory, use a formula tool to consistently name your files (Jan_Week1) so it is easier for the user to search. Now you can convert this into an app and give your users either a drop-down or a textbox. You will have to account for all the user input errors and handle them in your original workflow.
In cases where your files have inconsistent schemas, you can normalize them using a batch macro.
Hi @Pragya_Shree ,
do you already know the concept of an "Analytical App"?
Sounds like that is the solution for you:
Best regards
Phil