Can we include the sheet name as a field using Dynamic input on multiple sheets excel?

Question

Hi There,

I have multiple sheet on a excel name "March-2023", and "April-2023", with Dynamic input tool I can joined the data to one output. But, I what to use the sheet name to identify where the data come from.

Please let me know if I can do that?

Thx,

Robert

gautiergodard · Accepted Answer

Hey @rnguyen99

You can select this option in the dynamic input.

Full path of the file will include the sheet name at the end which you can parse out.