null values problems in convertToString

, ,
1

I am using wm.b2b.edi:convertToString service to convert a record list to a character delimited file.

The values in the record list are retrieved from the DB, some of the fields can be null. The problem is that convertToString returns is not working properly with null fileds. I am getting the errorArray full of: ‘fieldname’ field not found in segment ‘SEGMID’ [EDICOR.000020.000058] error messages.

How should I do to obtain something like this:
Values:
RecordList
SEGMID
Field1 - one
Field2 - two
SEGMID
Field1 - three
Field2 -
SEGMID
Field1 -
Field2 - four

etc…

desired result I expect:

SEGMID,one,two
SEGMID,three,
SEGMID,four

Thank you in advance

Sorin

2

I am also facing similar problem…any fix or solution on this. How can I get this working ?

Atul

3

Hello,
Why not make your null values into blank strings. Their is no distinction to go in the reverse without choosing that the specific ‘null’ word be stored or that no segment exist.
It helps to not use nulls at all in transformations unless it is needed as a separate entity and has a encodable format. Even in those cases, their is usually a tangible format or object to represent the null. Good day.

Yemi Bedu