Add sheet name when importing multiple sheets

[peterlyngvig]

Hi

I am trying to create a workflow, where I import multiple sheets using the Dynamic Input function.

I have managed to include a column in the output, which says "2021" i.e. the file name, but I would also like to add a column, which includes the sheet name e.g. "1", "2" etc. In other words, my end game is to add two columns one with the file name and one with the sheet name, so I can filter the date based on where it origins.

See attached input file and workflow.

Appreciate your help :)

Best,

Peter

[IraWatt · Accepted solution]

Hey @peterlyngvig,

In the dynamic input select output 'Full Path':

Then you can get both the file and sheet names with some parsing:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Emmanuel_G · Accepted solution]

@peterlyngvig 

Find in attachement the way of doing that easily with regex tool.

You can extract the fullpath with sheet names of excel file and then extract desired informations as shown below.

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it helped. 🙂