community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Macro to iterate through files in a directory

Highlighted
Atom

Hi, thank you for your example workflow and macro.

 

I used it as a model for my situation (a control table containing one row for each customer - including a filepath field and several other fields). I can successfully loop thru the companies and read each file using your technique. However, I also want to access other fields in the control table - say, company abbreviation, which I want to use in a formula to include in the output along with other info from each file. Not sure how. Thanks for any thoughts. 

Labels