General Discussions

Discuss any topics that are not product-specific here.

Output Starting from second row

chordiyanikhil
5 - Atom

Hello,

I need my final result / data to start from second row in excel. I am using formula and output tools to generate the output file, please help me how to achieve this. See the attachment to check how the result should look like

Thanks
Nikhil Chordiya

3 REPLIES 3
caltang
17 - Castor
17 - Castor

When you output, you can specify the range at which the output file starts like so:

 

image.png

 

Try putting the output tool again, then choose your file type, then specify the range by ticking the box and putting the location. You can put A2 onwards and for the last bit just put the column you want to stop at - doesn't have to have data btw...

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

@chordiyanikhil Did it help? If yes, can you mark as accepted solution to close the thread and help others find the solution faster? Thanks!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
TimN
13 - Pulsar

Here is a way.

Labels
Top Solution Authors