This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @ms809! I would use a batch macro. I think you can copy your Dynamic Input and Sample tools to a new a new canvas, add a macro input and macro output, throw some default data into the edit data option on the macro input, and then change it to a batch macro on the workflow tab before saving it. You can then add this macro on your original workflow in place of the dynamic input and sample, connect the formula tool to both connections on the batch macro, and select whatever field your dynamic input is using as a grouped field in both boxes of the macro configuration.
That can be confusing if you've never used batch macros before, so I've attached a sample where it will read in any xlsx file you give it and skip the first 5 rows. It should help in case you get stuck on any of the above steps.