Unclear on Iterative Macro output methods

Hi,

I built an iterative macro today, which works great (and is based on a very helpful post by @AdamR_AYX), but I am a bit confused about how the macro returns results based on the Output Mode settings. If I select "Auto Configure by Name" (which is what Adam had in his example, and which makes logical sense), I only get the first record from each iteration returned in the macro output. But if I select "All iterations will have the same output schema", I get all of the records returned.

macro config.png

My macro is set up very similarly to Adam's, so I would expect it to behave the same way. So just a little confused...I'm happy that I get the results I need, but I'm unhappy that what I would take to be a logical configuration setting doesn't produce the results I would expect. :-) . Any insights would be appreciated.

macro workflow.png

Workflow

Output

Macros

Iterative Macro

Accepted answers

JohnJPS

Hi @mix_pix,

My understanding is that it's basically a union taking place between all iterations of the loop: each iteration result value gets unioned with the results of all previous iterations. So, if you understand how "Auto-Configure By Name" (or Position) in the Union tool, the same concept applies here. In your macro, for whatever reason, it may be that field names are different between iterations. Things to try: you could also try auto-config by position, if it's always however many columns of basically the same data; or (preferable, I'm thinking) you could put a select tool prior to the output to ensure that you always have the same field name and type going to the output.

Hope that helps!

John

All comments

JohnJPS

Hi @mix_pix,

Hope that helps!

John

mix_pix

Hi John,

Thanks for the reply. What is thoroughly weird is that I changed my macro to 'Auto Configure by Name' (the setting I had tried initially), saved it and then re-ran the workflow (changing nothing) and the output worked as I had expected it to originally. A bit baffling, but it's working as it should, so I guess I'll just chalk it up to gremlins. :-)

Elyssa

Hi @JohnJPS

Dragging this one back to the surface.
I'm facing the same issue as mix_pix had. Macro runs successfully but the output I get is the union of the first row only.

Expected: 52 iterations which output ~7k rows in JSON format (JSON_Name | JSON_Value) -> unioned = approx. 360k rows

Actual: 52 iterations unioned = 52 rows as I only get row one per output.

I can tell that each iteration is successful, as the first row would otherwise fail & no further iterations output.

I've added a select tool to ensure that the only outputs are JSON_Name and JSON_Value, but still no luck. Seems like it might be gremlins, as mix_pix said, but no luck with just saving & reloading it yet.

Thanks,
Elyssa

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703