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

[MysticalAz]

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. 

[gabrielvilella]

I encourage you to use these macros.

[MysticalAz]

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.

[MysticalAz]

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

[gabrielvilella · Accepted solution]

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

[MysticalAz]

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