Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

formula tool to get connection name

avuong6
8 - Asteroid

i have this work flow that works:

avuong6_0-1674100003248.png

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)?

 

3 REPLIES 3
apathetichell
20 - Arcturus

Use Dynamic Input In-DB. It takes two parameters - Connection name and Query.

avuong6
8 - Asteroid

please bear with me as im a beginner at this.

 

where do i put it to achieve this? after the join?

avuong6_0-1674137833026.png

if i do that, the parameters are just my column names:

avuong6_1-1674137868768.png

 

 

apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors