Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do I set output to skip the first 3 rows on a pre-filled template

Jake5
8 - Asteroid

Hello.  I have a workflow I'm in the process of building where I need to take data from an input file and have it write to an output template beginning on row 4.  Rows 1-3 of the template should remain as is and not be impacted by the workflow.  The template contains SUM formulas beginning in cell G3 and those should remain intact.  I've included the workflow along with the input file and output template file.  Right now I'm getting an error message "Unable to overwrite a cell that contains a formula:  G3..."  How can I address this?

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

What happens when you set the range to start in row 4

instead of row 3? The error is saying you have to avoid overwriting row 3, and that’s what you want anyways since they need to stay in tact

Qiu
21 - Polaris
21 - Polaris

@Jake5 
I am not quite confident that I understand your intention.
but a few point I have noticed

1. The range for output shall start from A5 not A1

2. We should not output the Header

3. Maybe Sample tool can be used to ignore first a few rows.

0610-Jake5.png

Jake5
8 - Asteroid

Thank you both!  That was very helpful.  

Labels
Top Solution Authors