Alteryx Designer Desktop Discussions

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

Output data tool - issue to overwrite a worksheet

Elena_B1
7 - Meteor

Hello.

Could you please help with the message below? I'm trying to overwrite data in existing worksheet. 

 

 

Elena_B1_0-1665466359171.png

 

Elena_B1_1-1665466460907.png

Thank you

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @Elena_B1 , Please check the range mentioned in output tool and in the file you are overwriting to. Else you can share the file because in my case if I am overwriting a file not facing this issue. You can also try out with some other file and then troubleshoot the error by comparing both workflows. Also check if the file is being used or open in some other place.

Sapna Gupta
Elena_B1
7 - Meteor

it is still not working. I have two output data to write into two worksheets in the same excel file. the first one works as expected and the second one gives the warning message.  

Elena_B1_0-1665511156151.png

I tried to run the workflow separately for output 1 and output 2 by placing them in a separate container and disabling the flow for one output and running it for the second one. There were still no changes. 

Elena_B1_1-1665511446702.png

Appreciate your help. Thx.

Elena_B1
7 - Meteor

I found the issue. The name of worksheet in excel does not match to the name of the output data.

"Alteryx Transaction Details$A1:AI10000" Alteryx  vs "Alteryx Transaction Details from GL" workbook.

 

 

Labels