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