I am reading several files in that all run through the same flow but they all go to different databases on SQL server (i.e. db1.dbo.table, db2.dbo.table, etc)
I would like to create a single flow for all of them and not have to brute force filter them and then create different outputs for each table. I understand that under the Output Data" tool that we are able to change the name of table based off of a column but I am not able to find a way to dynamically change the database name.
Has anyone been able to accomplish this yet?
Solved! Go to Solution.
Hello,
Hope this will resolve the problem.
Create a formula with the database name for each different output new column.
2- Create a formula to update the database
3- Make sure to change the entire file path a the output
4- It works fine for me
Hope that will help 🙂
Regards,
Thank you. I wasn't selecting that in the dropdown. That fixed it!