Trying to stack multiple CSV files with different schemas using Dynamic Input but failing?

Hi All,

I know dynamically inputting numerous .CSV files with different schemas is possible, however I'm not sure why I'm unable to do it. I tried using a wildcard in my Input tool with a *.csv extension but that failed. That's when I realized I had some different schemas. I then tried a dynamic input tool and the Macro found here:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

but I'm still unable to pull in my fields because I'm receiving the different number of fields warning. I've attached a few of the files I'm attempting to stack to this - any help would be greatly appreciated!

Datasets

Developer

Input

Error Message

Macros

Transformation

Help

Dynamic Processing

Preparation

Interface Tools

Iterative Macro

Accepted answers

BrandonB

You may be missing the step where you go to view->Interface designer and in the settings change the option to Auto Configure by Name

All comments

BrandonB

This is a nice article that explains how to address your issue: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

I normally like to take the batch macro approach. It only takes 3 tools and allows you to bypass the schema differences messages.

hydrogurl01

Hi @BrandonB ,

The batch macro tool is what I've been trying to use with no luck, unfortunately. Only the files with the same schema are being read in. The others I'm receiving a warning stating that "...(file name) has a different number of fields than the 1st file in the set and will be skipped". Any advice?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703