Hi,
I want to read multiple workbooks with multiple sheets at once and all files and all tabs have same structure. I build macro in below steps:
- read files using input tool. Set Table or Query to 'List of Sheet Names'
- then used Dynamic input tool . set to field to Sheet Names and Action as Change File/Table Name
I am getting error as Different Schema than the first file.
I tried few more macros and workflow from the discussion forums but still getting the same error.
Is there a way to fix the schema in the file itself or other ways to resolve this issue?
Thank you very much!
