Iterative Macro Sort Before Final Result

[Alc2020]

Hello,

I was able to make my iterative macro finally work but I have a new issue and any help would be great.

My macro lists 100 records for each iteration.  It stops after a certain criteria has been met.  How can I sort all the accumulated records for each iteration before final macro output result?

Thank you.

[Qiu]

@Alc2020 

Do a sorting before the iterative output?

[Alc2020]

@Qiu I have already tried but that works only for each iteration.  If I have 4 iterations in total each record results are sorted for each run but not sorted as a whole in the final output.

Thanks

[AkimasaKajitani · Accepted solution]

Hi @Alc2020 

After Iterative Macro, you can connect Sort tool.

Inside of Iterative Macro, it is not able to sort all output data.

[Alc2020]

Hi @AkimasaKajitani I have tried that already but after the run completes.  It spits an error and sort tool says no data to sort but the result leg prior to the sort tool has the data 

Thanks

[AkimasaKajitani · Accepted solution]

Would you restart Designer?

If that doesn't fix it, could you please upload a screenshot of the workflow?

[Alc2020]

@AkimasaKajitanithank you!

Sorry that was my bad.  I did not set the fields tjat I need to sort during my first attempt.