This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
I have a workflow borrowed from somebody. It has a macros in it with the Input folder that links to one of the sample files. The macro in itself is running fine but when I connect it to Directory(folder containing all the input excel files) , macro is not reading other files apart from the sample file I inputted. How do I make my macro read all input files from the directory?
yes i do see that the output of macros is pulling data from all the files that are there in the directory, but not sure why the output file is just showing one record . Seems like issue with the other parts of the workflow then.
@simasarry123 Does the macro have a Control Parameter in it? And is it using the Dynamic Input tool? You may need both of these to have the macro read the data from 1 file at a time and then union them together. I've attached a sample workflow that should cover your need. See the container labeled '7. Even More Dynamic . . .' You can open the macro by right clicking on it and selecting 'Open Macro . . .' From there you can compare your macro with this one to see if you can determine what you need to add to your macro. If this does not help completely, please post a sample workflow and macro so we can see what's going on.
@simasarry123 - you should be able to open the file, even if I have a later version. The pop up is just a warning that should ask if you want to open. There are not any newer tools in the workflow/macro that would make it incompatible. If you're getting a different error when opening, please share a screen print.
Thank you for the information on the Interface tool / Action tool. You'll also need to use a Dynamic Input tool. Do you have that?
Here's a screen print of the macro, but it would help to open the file so you can see the configuration of the tools. The Select and Append tools are optional.