Hello,
I want to run this work flow but for 18 different departments, to create 18 different files. Basically changing dynamically the dept_id, based on a list of department numbers. Is there a way to do this using macros?
Hi @jfaubert
Get rid of the dept id filter and update your output tool to this setting. This will produce one file for every department.
Hi Luke, but I do want to filter the data so that the new file only has the data of that department. Then once done, I want it to go to the next department automatically. And then the next one, etc.
That worked!!! Thank you so much!!