Creating Iterative Macro

[DattatrayPatil10]

Hi Alteryx Engineers,

Hope you are doing well.

I am trying to create iterative macro with below details. Can you please help me out of this ?

Output Column name -  "Ques Route Id"

Input Data  -  Level  and  QuesDefn Id.

Note: Attached formulas tool logic, Hope it will be help you while creating macro.

[Ben_H]

Hi @DattatrayPatil10 ,

Can you provide some dummy/sample data rather than screenshots.

Regards,

Ben

[DattatrayPatil10]

Hi Ben,

Thank you for connect.

Input Data file attached.

[Ben_H]

Hi @DattatrayPatil10,

In your desired output where are the values 00005 and 00006 coming from?

As in why specifically does it start with 00005? It doesn't seem to be something that can be derived from the sample data.

The data doesn't seem to have any grouping the makes it clear that this set of rows belongs to a specific question.

Regards,

Ben