Batch macro Error help

[AC]

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:

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. 

 

 

[geraldo · Accepted solution]

@AC 

change the formula to

e the action tool to:

[acarter881 · Accepted solution]

@AC Please see attached.

[AC]

Thankyou @geraldo @acarter881 . It really helped.