Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Macro Batch Input | For .xlsx files

maier_alexander_MO
8 - Asteroid

Dear all,

 

I have already used the attached macro and workflow snippet as a batch input. 

 

What I want to do is read in all .xlsx files in the respective folder - however the output i receive is only the first line of the first .xlsx file. 

I already tried everything and cannot find the reason for this...

Could you help me regarding this issue?

 

Thank you very much in advance.


Kind regards,

 

Alex

4 REPLIES 4
joshuaburkhow
ACE Emeritus
ACE Emeritus

Hi @maier_alexander_MO 

 

You need to look into using the dynamic input tool. So you feed the directory input into the dynamic input tool to pull the data from that file 🙂

 

 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
fmvizcaino
17 - Castor
17 - Castor

Hi @maier_alexander_MO ,

 

The only thing that I would remove is one of the control parameters from inside your macro and leave only the second one.

fmvizcaino_0-1580131973719.png

 

Let me know if this works for you.

BEst,

Fernando V.

danilang
19 - Altair
19 - Altair

Hi @maier_alexander_MO 

 

Both of @fmvizcaino and @joshuaburkhow's solutions are good, but if you're getting this message 

 

down.png

 

It's because there's nothing connected to the output of your macro.  In this case Alteryx just runs 1 iteration to determine the schema.  Connect any other tool after the macro in your main workflow and it will process all the files

 

Dan

 

 

maier_alexander_MO
8 - Asteroid

Dear all,

 

thank you so much for your quick replies and help on this! In the end it actually was the fact that there was no tool attached to the Macro - which I would have never thought about..

Have a great day and kind regards,

 

Alex

Labels