We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Input - adding tab names

sgrabish1
8 - Asteroid

I have a workbook that has multiple names tabs.

 

I have used the Dynamic Inputs tool to pull all the information from each tab together; I would like to add another field to the combined data that specifies which tab the information came from.

 

Any suggestions on how to do this.

 

Greatly appreciated!

 

Stan

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hi @sgrabish1 ,

 

There is an option on the dynamic input where you can output the filename. If you change it to < Full Path >, you will be able to see the file sheet from which your data has been selected.

 

After you can trim the whole path to just have the filename with a regex tool or formula tool.

 

Untitled.png

cheers

sgrabish1
8 - Asteroid

Appreciate the help!

 

Stan

Labels
Top Solution Authors