Dynamic Input tool Related

[Jaganmohan]

Hi Team,

need your support on below query.

I have multiple input .xls files in one folder (Example - Input1 & Input 2 are in given folder) and all the files having same format - i need to combined all the files  data into one file same like attached format (Output).

[apathetichell]

These are .xls files not .xlsx. You will not be able to do what you are doing with dynamic input. .xls files require a python/r/vba/command line integration to retrieve a list of sheet names.

[Jaganmohan]

Hi - Is there any alternative solution for this query ?

[albert_alaluf]

It is not very practical, but I saved all .xls as .xlsx, then dynamic input. Let me know this works.