Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Dynamic Input Help

elclark
Astéroïde

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 RÉPONSES 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.

 

Étiquettes
Auteurs des meilleures solutions