Iteration number for Each record

[prakhar021]

Hi All, 

Is there a way in Alteryx to fetch iteration number for each record in Alteryx. Like I wanted to know for each record what is the number of iterations. If yes then what is the way. Please help me 

Thanks 

[Raj]

@prakhar021 
usually, iteration no is record id -1

hope this helps.

[prakhar021]

@Raj

I have used Record ID but I am getting distinct record ID. If I do record Id -1 then it will result the same 

Please note. I want that a particular record has been iterated how many times 

[Raj]

@prakhar021 
are you trying to add iteration no in front of records generated by your iterative macro?

[prakhar021]

 Yes, That's exactly what I want. Also It should be another column as 'Iteration Count'. Which will show each record how many it has been iterated.

[Raj]

@prakhar021 
add a formula tool in your macro naming "iteration no" with formula "[Engine.IterationNumber]+1" this add a column with iteration no.

mark done if solved.

[prakhar021]

It's not giving the count of each record. It's giving at what position each record have been iterated.

[Raj]

@prakhar021 
can you share your expected output, input and the workflow you created
will be in better position to help.