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

Getting SPecified Range is not large enough for incoming data field output error

SR
8 - Asteroid

I am writing the output to excel files using the parallel block until done (Crew Macros) as i have mutliple data elements to be written on different sheets.

 

on the last 2 outputs i am getting this error : SPecified range is not large enough for incoming data fields. never seen that error before and not sure why its coming. the data where i am getting this error has like 43 rows and 10 columns .

 

Any suggestions will be helpful

 

Thanks

 

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

Are you specifying in the output the range (e.g. A1:H10) for output?  A picture of the output configuration (all options displayed) would be helpful.  If in your user settings, you have the XML displayed, that would be helpful too for the output tool.

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
mmenth
11 - Bolide
SR
8 - Asteroid

a similar way worked for. i updated the sheet names and it was able to output properly. still not sure why the original sheet names were not working (they were new sheets).

 

Thank you all for your inputs,

Iggles
6 - Meteoroid

Did you have a sheet name that was the same as a named range name by any chance? I was getting the same error and it looks like that's what caused it. I wanted to write to the sheet but it was probably trying to write the output to the named range instead. Changing the sheet name fixed it, obviously.

Labels