Include Excel Sheet name in output dataset using Dynamic Input tool

MaverickVZ

I may be overlooking something obvious but this is the first time I'm using the Dynamic input tool and I need to add the name of the Excel Worksheet (Table) to the dataset. My Excel Workbook has 43 tabs each one named by month. "Dec-14", "Jan-15", "Feb-15" etc. Using the Dynamic Input tool I am able to Union all the data into one output but I have no way of telling which sheet it came from for a summary view. I need to bring the Worksheet Name into the data so I can summarize it by month. I don't want to manually add it to each sheet and then import it. Any help would be greatly appreciated.

Thanks,

Pete

MichalM

Hi Pete

You can use configuration of the Dynamic Input tool to append Full Path of the file and sheet as a column to your dataset. When selecting the Input Data Source template, make sure you select 'Full Path' in the 'Output File Name as a Field' option - row 5 in the configuration. You can then extract the sheet name only easily using the Text-to-column tool.

Hope that helps.

Michal