Column header repeat

[r.julia]

Hi,

I have a record like this:

|Number|Name|Country|
|9|Henry|France|
|10|Rooney|England|
|Number|Name|Country|
|10|Zidane|France|
|Number|Name|Country|
|3|Cole|England|

I want the output to have only the first column header and then the data:
|Number|Name|Country|
|9|Henry|France|
|10|Rooney|England|
|10|Zidane|France|
|3|Cole|England|

Thanks
J

[sachin1]

hope before processing this file you can use unix sort command ........

[sachin1]

hope before processing this file you can use unix sort command ........

[r.julia]

I cant sort. The data comes in a manner that ordering it is not advisable.

[ArndW]

In the transform stage just check for @INROWNUM greater than 1 and the columns eq to your header value of "|Number|Name|Country|" and just don't pass that through to the output.