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.
SOLVED

Iterative macro not working

SH_94
11 - Bolide

Hi community,

 

I would like to ask about the macro built. I have the macro to read each text file but not sure why it only keep iterate one file multiple time and not sure where go wrong.

 

SH_94_0-1756464080436.png

 

May i know how to fix this or any things i need to take note?

 

Many thnaks in advance.

 

1 REPLY 1
caltang
17 - Castor
17 - Castor

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

 

Don't choose the "Replace a specific string" option down below. Make sure your input from the batch macro is just a bunch of FullPaths via a Directory tool, then it'll read in all the .txt files accordingly. Filter and adjust as you see fit.

 

Make ssure to go into the Interface Designer and check your selections accordingly because the .txt files could have differences which you may not be aware of - in terms of placements, names, data types, etc. 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors