In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Pulling future excel sheets into an Alteryx flow

Bluesky
5 - Atom

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!

1 REPLY 1
rkapoor
Alteryx
Alteryx

@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.


RishiK_0-1625212883499.png