This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
If you have installed from the yxzp file, it’s is likely that you are running a prior version of Alteryx compared to the version that @aruiz-itp built. If you separately open the yxmc (macro file) in designer, save it and then reopen the yxmd file it should work.
Chris Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Yep i was running an older version of Alteryx. After the update it fixed the import issue. The import worked nicely and brought in all the records from the multiples file i had. Last question is - I want to add a field to this workflow that tells me what file the data is coming from. What's the best way to do that?