Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Trouble Appending Alteryx Output to existing Excel Template

Aviator0807
8 - Asteroid

I am trying to append my output to the table below. I manually mapped the fields in the output data tool. So everything  lines up fine. The problem is the data is 5535 rows below, it is doesn't start in row 4 like I want/expect it to. AM I doing something wrong? How can I get my data to append at row 4 and not row 5535?

Aviator0807_0-1625675064020.png

Aviator0807_1-1625675144931.png

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Aviator0807 

 

Select output tool output option as overwrite sheet. Since you are writing from range above rows wont be affected.

Aviator0807
8 - Asteroid

@atcodedog05

It gives me the following error

Output Data (105) Error: Encountered existing data beyond the specified range

atcodedog05
22 - Nova
22 - Nova

Hi @Aviator0807 

 

Give range like A3-Z99999 which is a large range.

 

A3-T3 is a single line range which wont fit.

Aviator0807
8 - Asteroid

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Aviator0807 

Labels