Free Trial

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
Top Solution Authors