Input Multiple Excel Files using * and fixing different file schemas with batch macro

oracleoftemple

I'm importing multiple excel files from the same folder using a wildcard (*), and when I import all files it ignores some saying that they have a different schema than the first one.  All the rows are named the same, but it looks like Alteryx is assigning different data types to some of those fields.  I have read the post called "Importing multiple excel files" so I know what the solution is.  I should create a batch macro that uses the Select tool to make sure all columns have a consistent type from file to file.

My problem is that I don't know HOW to make a batch macro.  Can someone walk me through this?

DavidP

This is a great article that explains how to do it

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-multiple-files-with-different-Field/ta-p/13370

And attached is a macro already written and a workflow to run it. The workflows expects the macro to be in

C:\ProgramData\Alteryx\Macros

If you put it somewhere else, you'll just have to delete the macro from the workflow and add it back in from your macros tool palette

New Workflow4.yxmd

excel file load macro.yxmc