Dynamic Input - adding tab names

[sgrabish1]

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

[afv2688 · Accepted solution]

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.

cheers

[sgrabish1]

Appreciate the help!

Stan