How to delete Rows 1 and 3

[bubblyjai1982]

Hi All

I have set of data where I want to remove row number 1 and 3 completely

Tried using "Sample Tool" to removed only two rows but this is not giving correct result instead its extracting a specified portion of the rows in data stream.

please find the attachment - only row 1 and 3 want to delete completely 

Many Thanks

[OTrieger · Accepted solution]

@bubblyjai1982 
There are several ways how to do it.
I would start the data from row 4 and then the line 3 will be the header. And I would replace the headers. The good thing in this method that you will get the correct data type for the fields.

Another way get the data from Row 2, so first line of data will be Row 3, Then you can filter the data based on field content and row 3, which will row 1 will be removed. In this case all your data will have string data type

[binuacs · Accepted solution]

@bubblyjai1982 

[bubblyjai1982]

Thanks OTrieger and Binuacs