Dynamic Input tool Related

Question

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).

Input1.xls

Input2.xls

Output.xlsx

albert_alaluf · Answer

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

Jaganmohan · Answer

Hi - Is there any alternative solution for this query ?

apathetichell · Answer

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.