Macro

Question

Good afternoon everybody,

I hereby seek your help, I have a question, I have the "Directory" tool with several ".csv" files, and I want the content of each of them, and I was recommended to run a macro (Attached) When I run it in worflow I get the error -
"Macro_teste (806) Error while reading xml: ParseError: unable to open primary document entity 'C(...)\Macro_teste.yxmc' at line 0 and column 0".

I appreciate any kind of help.

Macro_teste.yxmc

CoG · Answer

Also, as far as the macro error is concerned, it apparently has to do with special characters appearing somewhere (try the file path?).

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Error-while-reading-xml-ParseError-unable-to-open-primary/td-p/1136338

I'd start investigating there.

Edit: I ran the macro myself with no issues, so that would definitely be where to start looking!

CoG · Answer

If your files have the same schema, you can use the Dynamic Input Tool:

https://help.alteryx.com/current/en/designer/tools/developer/dynamic-input-tool.html

Dynamic Input Tool.yxzp