optional fields in sender FCC

[Former Member]

Hi All,

my source file is a flat csv file,

ex: 10,20,30,40,50

11,21,31,41,51

five fields in source structure.

fields 3 and 4 are optional .

in this case, when both the fields values are not coming ,how my source file looks like?

wat i mean is will it look like 10,20, , ,50 0r 10,20,50.

thanks and regards

jhansi

[Former Member]

Hi Chirag,

if it is like 10,20, , ,50 then the fields will exist in the xml structure with blank values. right?

then do we need to mention them as 0..1 (optional in ) corresponding xml structure?

jhansi

[Former Member]

HI,

Yes your XML structure will be created with no value inside it.

This will be the output.

<Data> </Data>

Yes you can define the occurance as 0-1 in data type.

Thnx

Chirag

[GabrielSagaya]

since fields 3 and 4 are optional

the input can be 10,20,,,50

11,21,,,51

[Former Member]

Hi,

The value in the file will be null and will be specified by 10,20, , ,50 otherwise your file content conversion will not create the proper XML strucutre.

Thnx

Chirag Gohil.