How to create a batch macro where the output of one row is used as an input in the next

[Loai95]

Hey all,

I am trying to fill out the starting amount from the ending amount of the previous row for each row. I want each row to be filled out before the workflow proceeds to the next row. Please find an example of the data attached.

Thank you

[clmc9601]

Hi @Jack6627,

I'm glad this will work for your use case, too! That error message means there was originally a column called [Inv# Beg], but Alteryx doesn't see it in your data. You can either rename your column to match or alter the macro input to show a field map, like in the attached picture. I hope this helps!