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

Want to remove row

Maheshp
8 - Asteroid

Hi Team,

 

In excel there are few unwanted rows which i don't want include in Workflow from 1 to 9, please guide how can i remove those rows through option.

 

Regards,

Mahesh

 
 
 

 

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @Maheshp, couple of options here!

 

You can either do this straight away in the Input Data tool by starting the data import at a certain line (10 in your case):

 

90.png

 

Or, after importing the whole file, you can skip the first 9 rows using a Sample tool, setting 'Skip 1st N rows' to 9:

 

91.png

 

Hope this helps!

Amit_G_Limbasia
8 - Asteroid

Please change the row number in input data configuration to get your problem resolved Capture.JPG

Labels