Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Reviewing Macro results

Highlighted
8 - Asteroid

I am trying to use macros.

 

The results with test data in the macro seems to be right, but when I run the macro with a workflow with a big data set, the results are not what I am anticipating. How do I review the data within the macro after running the workflow that contains the macro?

 

If I right click on the macro within the run workflow and select to show the macro, it opens it but without the data of the most recent execution. Am I missing something?

Highlighted
Alteryx Certified Partner

Hi @Muratie 

 

The simplest solution I can think of is to open your macro and use the larger dataset as the Template Input. This will enable you to run the macro as a workflow with that dataset and debug.

Alteryx Certified Partner
Alteryx Certified Partner

Hello @Muratie ,

 

If you want to use the most recent data that was input into the macro I would recommend you to do the following:

 

Run the workflow

 

Once it has finished, click no the input arrow of your macro. This will show you the data that was input into the macro. On the results window, on the top right corner click you will see a copy button. This will let you copy the data which you can then paste on the macro and will be shown as a text input. Right click then on the text input and convert it into a macro input.

 

Another way (if your dataset is a big one) would be to generate a temporary output yxdb file on your desktop on the same spot as your macro input so that both files get the same data. Then on the macro input switch the input data to be the newly generated file.

 

Cheers

Highlighted
8 - Asteroid

Thanks, this helped.

 

Would be great if we could feed it in on the fly through a debug process similar for user selected prompts...

Labels