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

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