Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch macro Error help

AC
7 - Meteor

hey Guys, 

 

would you please help me to resolve this error. I have to create a batch macro that should read all file name in directory and extract their column names with directory. I have create batch macro for it ( see attached snaphot 1 for batch macro) . Here I input all fields of directory and than on interface tool I have given  update value for all values inside formula (see snapshot 2) .  It works fine inside macro. but through error on main workflow.. I have attached workflow sample below.

 Batch Macro:

AC_0-1686935307559.png

 

On workflow , when I connect FilePath to the Macro it gives an error saying "Record #1: Tool#14 Parse Error at char(0):Unknown Variable:....". Tool 14 in macor is fomrula. Not sure why it is causing it. 

 

AC_4-1686935975534.png

AC_7-1686936073363.png

 

 

 

AC_5-1686935995916.png

AC_6-1686936011151.png

 

12 REPLIES 12
geraldo
13 - Pulsar

@AC 

 


change the formula to

 

geraldo_0-1686939353698.png

e the action tool to:

 

geraldo_1-1686939412082.png

 

acarter881
12 - Quasar

@AC Please see attached.

AC
7 - Meteor

Thankyou @geraldo @acarter881 . It really helped. 

Labels
Top Solution Authors