Free Trial

Alteryx Designer Desktop Discussions

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

Batch Macro Error using Directory Tool .txt files

mzlee
7 - Meteor

I am trying to use the directory tool to read multiple txt files. I am using a batch macro (attached configuration) but when I run the workflow the macro tool is giving me this error Record #1:Tool#1: Unable to Open file to read. 

 

I am also attaching the Directory tool configuration in case I am missing something there. 

3 REPLIES 3
apathetichell
19 - Altair

1) is the file open in another program.

2) is the file local - ie do you have access to it

3) can you share the config of the action tool?

mzlee
7 - Meteor

1) The file is not open in another program

2) It is a local file and I have access to it

3) Attaching the config of the action tool

apathetichell
19 - Altair

two things:

1) I believe your field length is beyond the max length of a vwstring. you should lower that to 2500000 or something.

2) I need to see the replace string/whatever's configed on the bottom. The next question would be for a sample path being fed in --- and a sample path in the action tool. 

Labels
Top Solution Authors