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

Alteryx Designer Desktop Discussions

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

Error Message - Pulling Excel File that Doesn't Exist

Kristie_Pires
8 - Asteroid

Hello there,

 

I have the following workflow (see below) where I am picking the first three files:

Kristie_Pires_3-1683751306401.png

 

 

The interesting thing is, I only have 3 excel files into that specific folder, but as you can tell from the first anchor, it's picking up 4 files. The 4th file is the one highlighted below - and that's the file I renamed as "Archived_Mar". I have no idea why this file with the "~" keeps showing up which is causing an error message.

Kristie_Pires_2-1683751010963.png

 

These are the only files I have in the folder:

Kristie_Pires_4-1683751396802.png

 

I hope you can help!! Thanks :) 

3 REPLIES 3
binuacs
21 - Polaris

@Kristie_Pires Add a filter tool after the directory tool and set the condition !StartsWith([FileName],'~')

geraldo
13 - Pulsar

@Kristie_Pires 

 

You are not viewing these files due to the configuration of windows folders.
option must be checked:
show hidden files, folders and drives

 

 

These files with ~ is when the file is open, when you close the file it disappears.
but if there is any unexpected problem, this file may get lost ~ in the folder

Kristie_Pires
8 - Asteroid

@binuacs I was able to filter out that file! Thank you 😉 

 

Thank you @geraldo - I checked the option to show hidden files, folders and drives and that file still doesn't show up. So, I am still unsure why I had the issue in the first place.

Labels
Top Solution Authors