Join multiple sheets from one excel file - header on only 1 sheet

Hi Community!

I have the attached sample document which contains 3 sheets. Headers only exist on Sheet1. Any idea how I can union them all assuming the schema will always be the same?

I attempted to create a macro (attached). In a new workflow, I then input the file, attach the macro and browse. Error below.

Join multiple sheets.xlsx

Multiple Sheets & Files Macro.yxmc

Datasets

Error Message

Common Use Cases

Batch Macro

Dynamic Processing

Accepted answers

gabrielvilella

You need to enable the option that the first row contains data on the input data tool in last macro.

Read multiple sheets.yxzp

All comments

gabrielvilella

I encourage you to use these macros.

Read multiple sheets.yxzp

mystasz

Thanks @gabrielvilella. This outputs my data in a weird way, is that what you're getting too?

gabrielvilella

The macro is set up to union based on field name, you can change that based on field position on the Interface Designer for the second macro.

Read multiple sheets.yxzp

mystasz

This seems to be ignoring row 1 in sheet2 and 3. Missing IDs 3 and 5. Any idea why?

gabrielvilella

You need to enable the option that the first row contains data on the input data tool in last macro.

Read multiple sheets.yxzp

mystasz

This whole approach is very different than what I was doing. Thank you very much.

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335