How to select columns on Dynamic input

Question

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?

danilang · Answer

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

OllieClarke · Answer

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-Field-Schema-Batch-Macro-1583459839440

Hope that helps,

Ollie

apathetichell · Answer

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