Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Not creating multiple tabs in Excel output in Gallery

1737280
8 - Asteroid

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.  


1737280_0-1622649190050.png

 

Region
East
West
North

 

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:

 

1737280_1-1622649467575.png

 

However, once I publish to our own Alteryx Server (private gallery), the Analytic App starts fine, showing the input screen:

1737280_2-1622649551207.png

 

And it runs fine and gives the Excel file for download.  However, in the Excel file, there's only the first tab:

1737280_3-1622649598450.png

 

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.

 

Thanks in advance for any suggestions.

 

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

Hi @1737280 ,

 

One thing you can check here is how you are constructing the filename at the end of the process.

Currently you are overwriting the filename with just the name of the sheet within the file.

 

In your macro, change the formula which is creating DataName to the following:

 

"Appt Data.xlsx"+"|||"+[Region]+"123"

 

mceleavey_0-1622652963109.png

 

Can you try this and let me know if it helps.

 

M.

 



Bulien

1737280
8 - Asteroid

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:

 

1737280_0-1622659936620.png

 

I'm starting to think if there's a bug in Alteryx Server??

SophiaF
Alteryx
Alteryx

@1737280 

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

 

 

SophiaF_1-1623063770534.png

 

Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
1737280
8 - Asteroid

That worked.  thanks a lot @SophiaF !

Labels