DSXchange

Hi

please could any one help me in this following issue.

Input file with || format
a||b||c||d||e
1||2||3||4||5
g||g||e||6

in 3rd row after 6 there is missing || Following is small job

Sequential File Stage---->Transformer------>Sequential File
|
|
|
Reject

In Reject file i am able to see the 3rd row of the file i.e the record with missing || in single Column, but the requirement say record should go further for business process. please could u help how can i get that record process. This is a parallel job.

Thanks

Read the file using a single VarChar field and parse it in a downstream Transformer stage, wherein you can handle the missing column appropriately (supply a default value?).

Thanks Ray

But we dont want to read the file in single VarChar field, is its possible to do it in different way.

Thanks

That's an odd requirement. How you read the file should not matter as long as you are processing all the records required. Ray's suggestion to read the file in a single field and using a Transformer Stage should work fine.

Pick up the rejects in the Sequential File stage with a reject link, reparse it (Column Import stage perhaps), generate the default value for the missing field (Column Generator stage perhaps) and funnel the two sets of rows back together.