Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Input Help

elclark
8 - Asteroid

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
2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

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
21 - Polaris
21 - Polaris

@elclark 
I usually use this one in such case.

 

Labels
Top Solution Authors