How to view output for a macro??

[njohn56]

How can I view a macro outputs to troubleshoot, Im unable to view it when opening the macro??

[danilang · Accepted solution]

Hi @njohn56 

Debugging macros is not an obvious process.  The first place to start is by making sure all macro messages are displayed in the calling workflow

With this checked, all the messages that would normally show up in the macro results window will show up in the calling program for each iteration of the macro, like this

Often times this is not enough.  This is where Message and API Output tools come in. 

The Message tool will output a specific message to the result window.  Adding this Message tool to the macro

adds these specific messages to the output window.  See Calling.yxmd for an example

The API Output tool will the send the contents of any data stream to the result window.  Adding one to a Standard or Batch macro(it's not allowed in Iterative macros for some reason) will add 2 sets of rows to output, a header row and one row for each row of data (Callingbatch.yxmd)

Dan

[jarrod]

Hi @njohn56 ,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

I just wanted to add a big kudos to @danilang for the creative use of the API tool. Very clever!

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!