Dynamic Input Help

[elclark]

Hello,

I'm trying to input all files from a folder; however, they don't have the same columns, only the first 4 columns of each file are the same and those are the only 4 columns I need to input. Is there a way to input just those 4 columns without having to do each file one by one? I would also append the name of the file as one of the columns. Thanks.

Column A

Column B

Column C

Column D

File Name

[Luke_C]

Hi @elclark 

You could use a batch macro to do this. Feed the file paths into the macro from a directory tool, then in the macro select the 4 columns you need. 

This thread has some examples:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Batch-macro-for-multiple-Excel-inputs-...

[Qiu]

@elclark 
I usually use this one in such case.