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
20 - Arcturus

@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