Creating Iterative Macro

Question

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.

Formulla for ID Genaration_.png

Iteration formula.png

Data.png

Ben_H · Answer

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

DattatrayPatil10 · Answer

Hi Ben,

Thank you for connect.

Input Data file attached.

Input Data.xlsx

Ben_H · Answer

Hi @DattatrayPatil10 ,

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

Regards,

Ben