Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Batch Input Macro Not Working

Guox0824
5 - Atom

Hi 

 

Hope someone here can help me.

 

I built a batch input macro for testing out my workflow, inside my input folder there are 3 files. Somehow the macro is only reading one file and combined the same file 3 times. Wondering if anyone has ever encountered this issue before?

 

Thanks

Mike

5 REPLIES 5
HomesickSurfer
12 - Quasar

Hi @Guox0824 

 

Please share your workflow and I can review and offer a solution.

Guox0824
5 - Atom

Thanks

 

Please see attached workflow. Do you need the other two input file? So apparently the workflow is just reading this one input file and combine the same data multiple times

 

mbarone
16 - Nebula
16 - Nebula

Hi @Guox0824 ,

 

In your macro, for the Action Tool, you have it configured with the "Input Data(1)" line highlighted.  This will do not change the input:
2020-11-18 09_25_23-Window.png

 

If you want to keep the setting as "Update Value (Defualt)", then you'd have to highlight the File - value entry and then check the Replace a specific string box at the bottom, like this:
2020-11-18 09_26_31-Clipboard.png

 

However, for this, I always prefer to use the option "Update Input Data Tool", and then you don't have to worry about it, like this:
2020-11-18 09_25_47-Window.png

 

That should do it.

HomesickSurfer
12 - Quasar

Hi @Guox0824 

 

@mbarone beat me to it.  He had identified the cause of your issue and provided resolution.

Guox0824
5 - Atom

Thank you guys, all worked!

Labels