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.
I have a SQL Server Query which is taking values from Customer Name and Date input and providing a specific report for a specific customer.
Now i have 60 customers in place, instead of running the workflow 60 times, i want to create a automation workflow where automatically the workflow will run for 60 customers one by one and it will send the output file to the specific customer folder in one go.
I do not know your format, however at the bottom of the output tool you are able to take part of the filename from a field. With this you can have a whole path from a field in your data to replace the file path you have in your output. Or just the filename and you would be able to have the name of your client in the output
You may need to leverage a formula tool before hand to get it into the format you want. With an example I can help create a workflow for you to help you visualize it.
Do you have Automation? You could input a list of users into a batch macro. Inside the macro it could update the sql query and push it to a file based on the user. If you have example data I can also create a workflow!