How to select columns on Dynamic input

[clarrock]

Hi,

I have multiple input files with different order of the columns but all of them have some common field names

Is it possible to input all these files by using the dynamic input tool by using a template that only includes the common field name?

The problem is that alteryx only unionises some of the files and ignores the others in the final output cause they dont meet the schema

How do i make sure that alteryx reads all the files and only the specific columns are in the output?

[aatalai]

@clarrock the dynamic input tool works only if the fileds are the same schema, a batch macro might help with what you are looking for though

[apathetichell]

As mentioned numerous times ---- Dont use dynamic input - use a batch macro. 

[OllieClarke]

Hi @clarrock 

Here is a blog explaining how to build the batch macro you'll need. You can drop unwanted columns with a select tool

 https://knowledge.alteryx.com/index/s/article/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-...

Hope that helps,

Ollie

[danilang]

Hi @apathetichell 

 

 The right tool at the right time! 

Dynamic input is easier to use and much faster if you know that the files have the same schema.  Examples of these are automated reports, financials, etc.  On the other hand, if there's even a chance that schemas may change then a macro is the way to go!

Dan