Input files extraction from folder
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I need to import the files from one folder but the challenge here is the folder name continuously changing day by day.
folder name = todys date.
so how can i import the files from the folder by not changing the file path every time - please guide me on this, thanks.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @Jaganmohan
A dynamic input will allow you to specify a path in your data, and read data from the file found at that path.
https://help.alteryx.com/20214/designer/dynamic-input-tool
You can build this path using a formula tool, and the datetimefunctions (datetimetoday() ), to create the path to your daily file.
You could also use a directory tool to scan the whole folder that these folders reside, and pick up the file that has last been created. This would again require a dynamic input tool.
Hope this helps,
TheOC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Does the file name change also, or only the folder? Does the prior folder still exist or is it completely deleted/archived?
