Error Message - Pulling Excel File that Doesn't Exist
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there,
I have the following workflow (see below) where I am picking the first three files:
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.
These are the only files I have in the folder:
I hope you can help!! Thanks :)
Solved! Go to Solution.
- Labels:
- Error Message
- Help
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kristie_Pires Add a filter tool after the directory tool and set the condition !StartsWith([FileName],'~')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
