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?
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.