DSXchange

Hi DS Gurus,

I'm doing the following job.

Hased File---->Transformer---->RowSplitter---->Transformer---->DRS database.

The job runs perfectly,but when the view the data in the target table, I observed that one column in the middle is left empty and all the columns
have been shifted to subequent column and I could see only first character of the last column.
The source hashed file has two columns.
column 1 is CRC number
column 2 has multiple rows of data merged to a single row in a previous job.(My job is to split that single row into multiple rows again here)

When I viewed the log, it gave me the following message.

CDC_V2_Row_Merge..Row_Splitter_35: read_fixedwidth() - row 3, too many columns in record.


I'm not able to figure to fix this issue.

Any help or suggestion would be greatly appreciated.

Thanks,

V.V.G

that third row is your culprit. Analyze it closely. I believe you are specifying it as fixed width. If you count the number of characters in that row, for that column, it will be more than what you have specified.