I have a set of text files in a directory that I want to input. I have been using a workflow that has been working successfully up until a few days ago. I tried dragging and dropping a single file, and it pulls in correctly, but when I add wild cards (*) to the file name, I get no results. This filepath works: D: \Users\Phoebe.Kelley\OneDrive - Whole Foods Market\Desktop\VIP File Staging for Upload to TD\28925_ITEM_105507.txt But this one returns nothing: D: \Users\Phoebe.Kelley\OneDrive - Whole Foods Market\Desktop\VIP File Staging for Upload to TD\*_ITEM_* I also tried using a directory tool to get a list of the filenames, but that returns nothing as well.

Directory and Input tools not picking up text files

I have a set of text files in a directory that I want to input. I have been using a workflow that has been working successfully up until a few days ago. I tried dragging and dropping a single file, and it pulls in correctly, but when I add wild cards (*) to the file name, I get no results.

This filepath works: \Users\Phoebe.Kelley\OneDrive - Whole Foods Market\Desktop\VIP File Staging for Upload to TD\28925_ITEM_105507.txt

But this one returns nothing: \Users\Phoebe.Kelley\OneDrive - Whole Foods Market\Desktop\VIP File Staging for Upload to TD\*_ITEM_*

I also tried using a directory tool to get a list of the filenames, but that returns nothing as well.

Input

Accepted answers

phoebe_kelley

hm, a restart seems to have fixed the issue, although now I'm getting an error writing to Teradata, but, different issue I think.

All comments

Wesley Mendonca

Hi @phoebe_kelley. Can you see if this "D:\" is a nickname for you directory? If yes, you should use the original name.

And you can also use two tools that can make the same : "Directory" and conect it with "Dinamyc input" tool.

phoebe_kelley

@Wesley Mendonca , thanks for the reply, but no, \ is what it looks like in the file explorer too (this is an Amazon workspace, so my default desktop is not in the C: drive). I tried moving the files to my desktop as well (rather than OneDrive) and still nothing. Although I could pull in each individual file, it is time consuming because they require editing the input parameters to pipe delimited, and no headers. This is a workflow I have to run daily, so as much automation as possible is key.

Wesley Mendonca

can you provide your workflow ?

apathetichell

Are you running via AMP? Is D local or network? What happens if you move your filter logic to a filter tool after the directory tool? (ie using like a regex_match logic for

regex_match([FullPath],"^.*\\*_ITEM_*\d+\.txt") - or something like that?

phoebe_kelley

hm, a restart seems to have fixed the issue, although now I'm getting an error writing to Teradata, but, different issue I think.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703