Hello,
I have 4 files (Classroom A.xlsx, Classroom B.xlsx, Classroom C.xlsx, Classroom D.xlsx) with similar Sheet name and column headers, but the first and last column have a different Type in each file (some are V_String and others are Double). Therefore, when I use the Wildcard function to input all at once, only 2 of the 4 files get loaded. The other 2 get a "different schema" error and are skipped.
Goal: I want all 4 files to load and I want the first and last column to read as V_String for all 4 files.
While this example is only using 4 files, my actual dataset contains 100+ files so my understanding from reading other posts is I should use a Batch Macro. I dragged the Control Parameter tool onto my canvas and linked it to my Input Tool, then I need help with the next steps.
Q1: In the Interface Designer Mode, what should I select under "Select an action type:"?
Q2: What should I do after selecting "Auto Configure by Name (Wait Until All Iterations Run)"? [If that's in fact the right setting to choose]
Q3: I need step by step guidance from there (I am confused how to actually apply the macro to the input tool and get the desired output). Screenshots much appreciated, thank you!
Solved! Go to Solution.
Hi @jaydelim16
Have you tried to follow this post? -https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...
Cheers,
Awesome this worked great - I appreciate you for pointing me to the right article!
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |