ROW Split

[vardhan354]

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

[DSguru2B]

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.