Dynamic input - how to add column with source sheet

[petr__]

Hello everyone,

I have excel file with 5 sheets, and I successfully used dynamic input for all sheets and got data, but I need to add column source sheet, which will contain data from which sheet is current record (i.e. sheet1, sheet2..)
I tried to set up via Action but I got errors and documentation is very brief for this options (missing examples etc..) any idea how should I did it?

thank you

[DavidP · Accepted solution]

Hi @petr__ 

When you set up the template file for the dynamic input tool, you can set the option to include fullpath as a field - this will also include the sheetname. You can then remove the filename and filepath. I'll mock up an example for you shortly.

[DavidP · Accepted solution]

Here's one I made earlier. The [Filename] field is the one you want.

[petr__]

Thanks you @DavidP  it works 🙂