Error on Reading in Multiple excel Tabs that have Different columns

Hi All,

Im unable to read all excel sheets in my excel file. All the excel tabs have different columns here im getting some error, but i have to read the data on all excel sheets.

Please suggest, im getting below error messgae.

Error: Warning: Dynamic Input (13): The file "" has a different number of fields than the 1st file in the set and will be skipped

Thanks& Regards.

Niranjan

Developer Tools

Macros

Dynamic Processing

Accepted answers

ShankerV

Hi @NiranjanK1

I assume, you want to read all the columns (fields) irrespective of different total number of columns you have in different sheets.

Please find the attached macro, which will help you to read all the columns without any error.

Kindly let me know if you have further more questions!!!!

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Error on Reading in Multiple excel Tabs that have Different columns.yxmc

Error on Reading in Multiple excel Tabs that have Different columns.xlsx

Error on Reading in Multiple excel Tabs that have Different columns.yxmd

binu_acs

@NiranjanK1 You should use the batch macro instead of the Dynamic Input tool if you are dealing with a different schema of data. The below post will give you an idea about how to use a batch macro to read data from different excel sheets and merge them into one

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

CombineSheets_010123.yxzp