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)