Dynamic filtering and file creation

[jfaubert]

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? 

[Luke_C]

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. 

[jfaubert]

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. 

[binu_acs]

@jfaubert as @Luke_C suggested you don't need to filter by department. The output tool will write each dept seperate output files. Attaching a sample workflow for your reference

[jfaubert]

That worked!!! Thank you so much!!