Replace all "Connection names" in 'Connect In-DB' tools in a file

[Manojkumar]

Hi Team,

I get alteryx files from other teams, in which they have a connection name specified in all the "connect in-db" tools inside a file. Every time i have to open them click on the tool and then change the connection name. Is there any way to replace all the "Connection name" in all the "Connect In-DB" tools inside a file in one shot?  ( I have to make 30 to 40 changes per file & we cannot standardize the connection names)

[patrick_mcauliffe · Accepted solution]

In Designer, go to Options --> Advanced Options --> Workflow Dependencies.

You can replace all at once for each named connection (ie if two tools have the same connection name, changing it here changes it for both).

[patrick_mcauliffe]

@Manojkumardid this solve your question?  If so, go ahead and mark it as solved so that others can benefit from it.

[Manojkumar]

Thanks, it worked perfectly