We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to pull only specific column names from excel sheets in batch macro?

mohit1999
5 - Atom

How to pull only specific column names from excel sheets in batch macro?

2 REPLIES 2
SPetrie
13 - Pulsar

You can use a dynamic select inside the batch macro to select or de-select the columns you care about.

That presupposes that your excel files all have headers in the first row or you only care about specific column letters. it can get trickier if the information you need to make a selection on is not obvious right away.

 

If you have example files and a bit more info on how you need to select them Im sure we can help out.

flying008
15 - Aurora

Hi, @mohit1999 

 

flying008_0-1686011870991.png

 

Labels
Top Solution Authors