DSXchange

The reason I want to use RCP is that I have to process nine different copybooks with hundreds of fields.
Any suggestions?

Ray, it works now.
But how to include all the fields into file schema in order to use RCP?
Thank you, Paul

Ray,
When I used your schema, I was able to browse only first and second columns.
FYI: Also, I want to use RCP on the transformer that goes right after Sequential file.
Thank you, Paul

You can get desired out put if you use a combination of Sort stage, Transformer stage and Remove Duplicate stage. In sort stage hash partition and sort the incoming records by Key. In sort properties, specify 'key' as previously sorted and specify EffDt and ExpDt to be sorted in asc order. Also set...

I have an input file: Key, EffDt, ExpDt The data looks like 1111 2002-01-01 2002-07-01 1111 2002-07-01 2003-01-01 1111 2003-01-01 2004-01-01 2222 2002-01-01 2003-01-01 2222 2003-01-01 2004-01-01 2222 2006-01-01 2007-01-01 I need the final result looks like 1111 2002-01-01 2004-01-01 2222 2002-01-01 ...