how ro filter file

Mhasan · Post by **Mhasan** » Wed Sep 26, 2007 3:24 am

Hi ,

I want to read only 1000 records form 3000 records FROM a Flat File using sequential file stage. how to sovle this situation

balajisr · Post by **balajisr** » Wed Sep 26, 2007 3:36 am

You can use Sequential file stage's filter option to filter the data.

Maveric · Post by **Maveric** » Wed Sep 26, 2007 3:40 am

Based on what condition do you want to filter these records? If you want only the first 1000 rows then set the property "Row Number Column" to a field say RowCount in the sequential file stage and then use filter stage to filter out the records on RowCount<1000.

balajisr · Post by **balajisr** » Wed Sep 26, 2007 4:05 am

If OP has to read only first 1000 rows then set "Read First Rows" option to 1000. Filter option is not required.

Unless OP specifies the filter condition we can only guess.

JoshGeorge · Post by **JoshGeorge** » Wed Sep 26, 2007 5:38 am

You can use Head stage. You have option to read N rows there. Else use Unix command in filter option of sequential file stage and fetch only first 1000 rows.