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

Alteryx Designer Desktop Discussions

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

Dynamic Input Tool Error

Will-G
7 - Meteor

Hi,

 

I've created a workflow to read the latest file in a folder and the sheet from the current month in that file (see workflow image). The Dynamic Input Tool part has an error saying "Can't find the file: ..." (see image of the configuration). Please could anyone help with this?

 

The files in the folder are of the form "01 FileName_Aug 2021" and "02 FileName_Sep 2021" etc. The sheets are 3-letter month abreviations and 2-number years (e.g. Jan 21, Feb 22 etc.). So overall the workflow aims to read the latest file and the current month sheet.

 

Many thanks,

Will

WillG_1-1631519296028.pngWillG_2-1631519313978.png

 

11 REPLIES 11
Will-G
7 - Meteor

Thanks for spotting the full path part. I've done this and changed the dots to underscores and still have the same message.

 

I've looked how the regular output tool reads this and added quotations marks and a $ to try and make it match. But still no joy!

 

WillG_0-1631526744147.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Will-G 

 

Dont do the 2nd step just do the first step.

 

Assign proper column in dynamic input tool.

 

Dont change dot to underscore.

 

@messi007 awesome job of spotting it 🙂👍

Labels