Importing Multiple Excel Files with same header and adding in a Filename Field.

jdelaguila

Alteryx Community, 

I'm trying to import Multiple Excel Files (.xlsx) from the same folder with the same headers.

However I'm encountering an error every time I run my workflow: "filename has a different schema than the 1st file in the set and will be skipped". 

I attached my workflow along with the 3 files i'm trying to import in. I thought it would be simple enough using a wild card * to bring in all the files but apparently it is not. Read a bunch of articles about using Macros but I haven't dug deep into building Macros yet or how to use them. 

The goal here is to setup a workflow that will import all files located in a folder (regardless weather its 1 file or 10 files), combine them (shouldn't be an issue as they all have same headers) and than create a field that tells me what file they came from. 

Appreciate any help here and thank you!

Javier

01_Engage_Cleanup.yxmd

SM_01082021_A.xlsx

SM_01222021_A.xlsx

SM_01212021_A.xlsx

randreag

yes open the macro and just select this option in the input tool

then saved the macro and close it.

Execute again the workflow and there will be the field