Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

Running workflow with excel binary output file

Rdata
5 - Atom

Hi I have a workflow that has two parts (adding fields/columns and pivot) that output to one excel file (two tabs). However, I have no issues when I output to an excel file (non-binary) format but when I tried to output the same workflow to a binary format, I get errors and I don't see an output option of "Overwrite Sheet or Range". All I see is "Overwrite File (Remove)" option. If I select this option, only one of tabs are showing in the output file. I tried to change up different output options but It seems that I get errors every time. Examples are errors saying it couldn't create a new tab (with "Create New Sheet" option) or no existing sheet (with "Append to Existing Sheet" option) etc.

 

Can you please help me understand this issue? Anyone? 

 

Thanks! 

1 REPLY 1
DawnDuong
10 - Fireball
10 - Fireball

Hi @Rdata 

Have you checked to make sure that 1) you have selected a tab and 2) Set the option to Delete data and append?

test XLSB.PNG