community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Cleaning the Rows

My input data set has multiple headers in the same columns as shown below:

 

Header 1Header 2Header 3
1AXYZ
2BABC
3CDEF
4DGHI
5EJKL
Header 4Header 5Header 6
6EMNO
7FPQR
8GSTU
9HVWX
10IYZA

I need to remove the additional Header row (4 to 6) So that I have one clean list with Headers 1 to 3

Alteryx
Alteryx

@ankitsingh2063 

 

A simple Filter should be all that you need.

 

filter.png

Meteoroid

Hi @ankitsingh2063 , 

 

Another way to accomplish it is by using a Select Records Tool:

Select Records.JPG

In the configuration window, you will specify the ranges of the rows that you want to keep. In your example:

1-5

7-11

 

Note that you can also use 7+ instead of 7-11. You would select all the rows beyond 7. The output will be:

 

Output.JPG

 

Regards,

Labels