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 created a Batch Macro that takes in a list of input records and writes the output to an Excel file creating one tab per record. I then added an Analytics App that let user enters input as in the screenshot below. The "Regions" is then split into multiple records based on the linebreaks.
This is fed into the Batch Macro as the Control Parameter. When I run the Analytic App in the Designer, I get the expected results in the Excel file, with three tabs created:
However, once I publish to our own Alteryx Server (private gallery), the Analytic App starts fine, showing the input screen:
And it runs fine and gives the Excel file for download. However, in the Excel file, there's only the first tab:
I have tried a few different combinations and still got the same different results. What might be wrong here? Please see my working Analytic App and the Batch Macro attached.
Hi mceleavey, thanks a lot for the suggestion. I tried it quickly but got the same results, that is, the output file locally from my Designer has multiple tabs, but from the Gallery, it has only the first one. I changed the Output Tool to "Change Entire File Path" and ticked "Keep Field in Output" this time:
I'm starting to think if there's a bug in Alteryx Server??
I believe this is happening because the tool isn't completing all the batches. Adding a blocking tool after the macro will allow all the batches to complete when run on the Server. I believe this is because the Browse tools don't execute on a Gallery run (they are meant for Designer).
Sophia Fraticelli Principal Support Engineer Alteryx, Inc.