hitmanthesilentassasin wrote:you have to define that in the filter option of the sequential file stage.
Hi HITMAN,
actually i will have two columns first column= filen name,second column=records detail.
i have to filter header and trailer from records column.
in my records column sample data will look like given above.
please advice
Define your file metadata to match your "detail" records and the others will be filtered automagically, assuming their record layout is different enough to be rejected by the stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:Define your file metadata to match your "detail" records and the others will be filtered automagically, assuming their record layout is different enough to be rejected by the stage. ...
Hi chulett,
i dont have any metadata.i have records in single column.
i am using sequential file as input.which will have two column.
1 column repreasent file name
2 column represent records of particular file.
from this colmun i have to remove header and trailer.
chulett wrote:OK, simple enough, then just use a contraint to filter out any records where the first three characters in your big field are "HDR" or "TRL". ...
Hi chulett,
please advice me .
i tried with dslink.column_name[1,3] <>'HDR' AND dslink.column_name[1,3] <>'TRL'.
as constraint.but its not working