Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Import File with variable path

prpanw
7 - Meteor
Tuesday

I have a daily report where source file saved at networkd drive.  I have developed workflow easily but If I want ot schedule workflow there is a problem on monthend becasue one monthend source file refresh on monthly export folder. Is there any way if dynamic tool easily pick latest file from folder and run the reprots.


Daily Path:-  \\UK01pfsr002\PRIVAPPS\CreditControlManagement\MOIRA\Daily Exports

Monthly Path:-  \\UK01pfsr002\PRIVAPPS\CreditControlManagement\MOIRA\Monthly Exports

 

File Nmae:- CE Combined Direct External.xlsx

Labels:
Reply
0 Likes
1 REPLY 1
binuacs
21 - Polaris
Tuesday

@prpanw use the directory tool to access your files and sort based on the creation time then filter the latest date then connect to the dynamic input tool and configure the full path , you also need to mention the sheet name in the path

image.png

Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All