Hi Experts
If any other way to consolidate in wildcard excel file's in the below scenario,
I have received the error message "has a different field name than the 1st in the set" due to one or more excel files' have additional column
File 1 - Column Heading 1 Column Heading 2 Column Heading 3
A B C
File 2 - Column Heading 1 Column Heading 2 Column Heading 3 Column Heading 4
A B C D
File 3 - Column Heading 1 Column Heading 2 Column Heading 3
A B C
File 4 - Column Heading 1 Column Heading 2 Column Heading 3 Column Heading 4
A B C D
You can give this article a try