DSXchange

hi all,
how to eliminate first two rows from source seqential file

thanks
Stheesh bab

sateeshbabu wrote:hi all,
how to eliminate first two rows from source seqential file

thanks
Stheesh bab

Hi,

For that u can use (Head -2) or else go before routine

P.S: make it clear where you want to use that so that you can get the clear picture you want like(Sequencer's or in seqentail file itself)

Regards..Naveen.K

Naveen.K wrote:For that u can use (Head -2) or else go before routine

head -2 gives the first two rows - it does not eliminate them.

Some shells allow the form head +2 which will eliminate the first two lines.

Otherwise use @INROWNUM > 2 as a constraint expression in a Transformer stage downstream of the Sequential File stage, running the Transformer stage in sequential execution mode.

Hi,

@INROWNUM>2 from the sequential file will solve this problem.

I am not sure about this........

Thanks,

SenthilP

Then try it. Under the conditions that I specified.

senthilt1 - Hint: The "@INROWNUM" and "@OUTROWNUM" mnemonics are available in the Transform stage.

Alternatively, you can enable Row Number Column in the sequential file stage. In the downstream transformer have a constraint as

@INROWNUM is by partition so if you have 2 partitions, you have to do:

@INROWNUM > 1 (1 per partition not 2) to eliminate the 1st 2 rows

use filter in options of sequential file

by using this unix command

/usr/bin/sed '1,2d'