i have this work flow that works:
after the join, the formula tool manually labels the sheet name. how to write an expression to label the sheet with the environment name (database connection name)?
Use Dynamic Input In-DB. It takes two parameters - Connection name and Query.
please bear with me as im a beginner at this.
where do i put it to achieve this? after the join?
if i do that, the parameters are just my column names:
Oh! I thought you had a connection name and wanted to control what you were feeding in - to extract the connection - use DYNAMIC OUTPUT IN-DB that will allow you to pull the connection name.