Sending data to different databases

[chukleswk]

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?

[messi007 · Accepted 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,

[chukleswk]

Thank you. I wasn't selecting that in the dropdown. That fixed it!