Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
RishiK
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