DSXchange

hi,

i am reading comma separted sequential file layout as follows

Header ---20150606NameOfile
Columname-columnID

records

trailer


i need to remove header ,column names and trailer so that i will load the records into the table.

i tried with filer option command sed '1d;$d' which only stripping the header and trailer part not the column name part and due to which i am not able to read the file.can you please help me on this.

This should happen automagically in PX if the stage only includes the actual metadata for the detail records. Then anything that doesn't match (i.e. everything else) should reject.