Write to More than One Excel Sheet - Receiving Error Message

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?

Developer Tools

Output

Accepted answers

alexnajm

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

All comments

alexnajm

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

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

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703