Using Wildcard for multiple files where one column size is not always same

[slckkrky]

Hello everyone

I have multiple fields saved in same folder with same naming structure however one of the field may have different size therefore wildcard reads only first file and doesnot read other files.

Is there any solution to this?

Thank you in advance

[binuacs]

@slckkrky use batch macro in your use case, you can configure the below macro 

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750