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

[rnguyen99]

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 solution]

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.

[rnguyen99]

thank you gautiergodard!