Dynamic Input Help

Question

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 AColumn BColumn CColumn DFile Name

Qiu · Answer

@elclark 
I usually use this one in such case.

Multi Sheet Import Example 2.yxzp

Luke_C · Answer

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-with-the-same-schema/td-p/592061