Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Iterative macro

rjadia
5 - Atom

Why is iterative number resulting into null on a nested iterative macro?

6 REPLIES 6
alexnajm
18 - Pollux
18 - Pollux

Without seeing any configuration, it's hard to advise. Best guess is that you are not passing your iteration number from your first macro into the nested macro

OTrieger
13 - Pulsar

@rjadia 
I agree with @alexnajm.

Additional data will help.

 

But what you can do run your first iterative macro and see if you are the desired result. If all working well, try the 2nd iterative macro, not nested, to see if you are getting the desired result. If both working well, then something is not configured correctly when you are nesting the 2 macros.

OTrieger
13 - Pulsar

But without data is very hard to tell, it is more guessing.

rjadia
5 - Atom

Thanks... let me try

rjadia
5 - Atom

The macro when run independently gives the result as needed. but when I nest them, the error happens on the macro, not in the nested one, with a null value. see the attachment.  "steps" is driven by "iteration" and is the nested macro and "level" is driven by "Iteration0". Iteation0 results into null value after first iteration. see the attached picture.

apathetichell
19 - Altair

hard to tell without seeing your workflow/data - but I'd see if perhaps the inner iterative macro isn't being triggers for some data. That would mean that it flows directly to your output from the outer macro. in a union all fields configuration this value would be null because the inner macro would not run -> and no value would exist for this field.

 

that's where I'd look without seeing anything of your data/workflow.

Labels
Top Solution Authors