Error while reading multiple files with similar schema.

Hi all,

I have created excel files based on the site wise. Usually the schema in all the files should be similar. But, the schema differs to few files. When I checked I got to know that, for the column called 'Calculated Segment' few Sites have data and few are Null.

Which ever the sites have Null Calculated Segments, they are throwing error as they have different schema. Please check the screenshots.

Please help to resolve this issue.

Best,

Teja.

Excel files generation site wise.yxmd

Reading the excel files.yxmd

Workflow

Error Message

Help

Accepted answers

messi007

@stj1120,

Yes it's because of the dynamic Read.

below how to resolve that:

1- Create a batch macro that will read file by file

2- Make sure that this option is checked in order to read even different schema files

4- In the read part I added the sheet name to the full path

Attached the packaged workflow and macro.

If this solve the need please mark it as solved it will help others,

Regards

ReadFiles.yxzp

ReadMacro.yxmc

CarliE

Hi!

What you can do is instead of replacing the full path in the macro, you can replace the filename instead. Attached is the package workbook. The macro will reference the filename instead of the full path and inside the macro, we will just replace the file name. All these sheets should automatically have that one "Sheet 1" tab from the file generation workflow you provided.

ReadingExcels.yxzp

All comments