community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Output to multiple defined ranges in same excel file

Meteoroid

Hi All --

 

I have an Excel template that I'm trying to populate. I have two streams of data and I need the outputs to go to DefinedRange1 and DefinedRange2. The ranges are in the same workbook but on different sheets, if that matters. For some reason I'm getting an error on the output for DefinedRange2 saying "Invalid Range. Check to make sure cells in range are contiguous, or specify a new range."

 

Please help! Thanks!

 

 

Bolide

Hi @malley003 ,

Can you delete and recreate range2  and try ?   

Meteoroid

benakesh -- doesn't work. I recreated the range, made a new range.. still got the same error. I also tried a Block Until Done to see if that helped -- but it didn't.

Bolide

Hi @malley003 ,

Attached  is a sample  wf to  output to 2 ranges  in 2  sheets . 

You can  share  sample wf with  input and output files if possible .

Labels