Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Help with Input Batch Macro Workflow

Highlighted
8 - Asteroid

@AbhilashR sorry...what are likely reasons for nothing to return from a macro? 

Highlighted
Alteryx Certified Partner

I would check to make sure the action tool inside the fileReadMacro is setup the right way.

Capture.PNG

 

Also check the string constructed in the newPATH formula and make sure it makes sense. I would check to make sure the folder location of your excel file + excel tab names names are populated the right way. 

1.PNG

Highlighted
8 - Asteroid

@AbhilashR thank you!

 

here are the settings for the Update Input Data Tool and output for the newPATH variable. The string for newPATH is correct as best as I can see.

 

sonseeahray_1-1585256063781.png

 

sonseeahray_0-1585255993565.png

 

Highlighted
Alteryx Certified Partner

Referring to the newPATH string in your screenshot, can you use it in an Input tool in a new workflow? I would like to test this string.

Highlighted
8 - Asteroid

@AbhilashR I will do that now

Highlighted
8 - Asteroid

@AbhilashR That's where my issue is! Thank you very much for hanging in here with me. I will work on resolving that!

 

sonseeahray_0-1585259073931.png

 

Labels