How to examine data flows within a macro?

A standard Designer workflow allows examination of how the data is being altered by each tool along the way. Often, the data has quirks that were not expected by the formula or join, etc.

How can one see what's happening inside a macro? The only method I've found is to copy the macro out to a regular workflow and repeat it several times to see what a few iterations would show. This seem clunky and slow. Any solutions? Thanks very much.

Macros

Accepted answers

SeanAdams

Hey @Newt ,

If you use the debug mode this does give a useful way to view the macro (as @rkapoor mentioned) but it doesn't allow you to see the second or third iteration.

What I've found useful is to put it in debug mode; and then use Input and Output to YXDB files instead of macro input and output - and then you can simulate how an iterative macro or a batch macro will work.

This allows you to debug and build your macros until you know they are working - and then go back to using Macro-input & Macro-output tools once you know that it's working.

All comments

rkapoor

@Newt you should be able to right click on the macro and select the "Open Macro:" option. You should be able to run the process within the macro end to end.

I'd advise that you run the workflow/macro in Debug mode:

https://help.alteryx.com/current/designer/debug-workflow

Newt

I'm examining the Help section's Sample Workflows / Using Scripting and automation / Appls and Macros / "03 Assign_Supply_to_demand.yxmd" workflow and its macro.

This workflow starts off with 14,568 pairs of supply and demand points that it feeds into the macro. However, when I try the Test View with Debug on the macro, the macro only starts off with 531 pairs. Is this expected? Have I set up the debug incorrectly?

This doesn't allow me to see how even one turn of the iteration works with all the data... Thanks.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167