How to read multiple excel files in one folder?

[izaychik63]

Look at
@mlauber71 example here

How to read multiple excel files in a folder and multiple sheets in an excel file?

Hi Iris, I am trying to read/consolidate data from multiple sheets and files in a folder. I have created the same workflow as given in the link shared by you. I was not successful in getting the desired output. I am not sure where i am missing. I have attached the workflow and the files for the reference. It would be very helpful if anyone can assist me on this. Regards, Pavan.Test.knwf (16.1 KB)