We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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
9 - Comet

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

Labels
Top Solution Authors