Pulling future excel sheets into an Alteryx flow
- 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
I am making an Alteryx workflow to put into a Tableau dashboard. I've already pulled historical information and now want to capture current monthly information / changes on an on-going monthly basis. I believe that a most of the historical workflow would work but what tweaks would I need to capture the information (current and future)? The current / new excel workbooks are located beneath a folder structure that goes several layers deep so I need to have the algorithm / workflow find certain parameters (e.g. year, month, folder name(s), and excel file name).
Thank you so very much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Bluesky not sure if this will help, but have a look at the Directory tool (https://help.alteryx.com/current/designer/directory-tool). By ticking to scan the sub-directories, you should be able to get key parameters that you need in the output.