In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Write to More than One Excel Sheet - Receiving Error Message

laurennewton
8 - Asteroid

Hi community! I found this solution to my initial issue.

 

I will link the post I found that I am using for my workflow: Saving Time With Advanced Excel Outputs - Alteryx Community

 

Here's my problem, I've configured everything exactly like the discussion post lays out with the exception that I changed the file paths to where I need to write the excels too. However, I am getting an error message on the output data tool that says - "Output Data: Specified range is not large enough for incoming data fields."  

 

This doesn't make sense to me because I specify to write to the Sheet "Workbook" cells A2 - A30000. And each file has less than 30000 rows of data. Please see below for a screenshot of my flow.

 

Any advice?

SCREENSHOT.png

laurennewton_0-1680291589042.png

 

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

Hi @laurennewton,

 

A2-A30000 assumes only one column - is that the case for your data? It might need to expanded to, for example, A2-Q30000!

apathetichell
19 - Altair

as @alexnajm pointed out - you are still only setting this for one column - how many columns are you sending in? Do you have a filename in a column? did you remember to toggle off including it in the "change entire path" lower quadrant of output data?

laurennewton
8 - Asteroid

H i @alexnajm and @apathetichell thanks so much for seeing my question and giving advice so quickly. I should've specifed better they are writing to cells $A2:AM30000". 

 

However I just made a silly mistake, I added a select tool on to my workflow to doublecheck my fields and I was attempting to write additional fields I don't need to the template and therefore it was throwing that issue. Once I removed the additional unneeded fields it began writing correctly.

 

Thank you both again for taking time to engage!

alexnajm
18 - Pollux
18 - Pollux

No problem @laurennewton! Please accept one or more of the response as a solution just so it shows as being resolved :)

Labels
Top Solution Authors