Dynamic Input: Check box to include a field with DATA SOURCE NAME

[Watermark]

In the dynamic input tool,

Where you “Read a List of Data Sources”, there should be a radio button below the “Action” field, to   

“INCLUDE FIELD OF DATA SOURCES”,

Then you’d have an output field with the isolated name from which the data was sourced. You wouldn't be required to "include full file path" then parse out the sheet the data came from. 

[Watermark]

I don't think my above description is very clear and apparently I can't edit it, so I'm including a picture of what I meant. 

 

Feed that  BP through.  It's especially relevant when you're doing a dynamic input and there are multiple sheets.