I have modified the Macro from this post https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
but when I run it, the output from the macro doesn't return to it's call.
Please help and Thanks!
Solved! Go to Solution.
@AbhilashR sorry...what are likely reasons for nothing to return from a macro?
I would check to make sure the action tool inside the fileReadMacro is setup the right way.
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.
@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.
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.
@AbhilashR I will do that now
@AbhilashR That's where my issue is! Thank you very much for hanging in here with me. 😃 I will work on resolving that!