Problems with subnodes in file content conversion

[Former Member]

Hi experts,

in a receiver interface I have this mapping:

Header

LIN

    field1

    field2

    PIA

       field2

       field3 

    DTM

       field4

So PIA and DTM are subnodes of LIN (=Lines).

In FCC convertions I have set:

RecordSet Structure = Header,LIN,PIA,DTM

and for each node:

node.fieldSeparator = +

node.endSeparator = 'nl'

The result is:

LIN+00002++11110141A:EN+PIA+1+11120141A:IN

QTY+21:100.000:PCE

My expected result is:

LIN+00002++11110141A:EN

PIA+1+11120141A:IN

QTY+21:100.000:PCE

I don't understand why PIA segment doesn't come in a new line.

Is possible to get my expected result?

Thanks

Fabio

[azharshaikh · Accepted solution]

Hi Fabio,

FCC does not support more than 3 level of Hierarchy, hence PIA is coming incorrect.

You need to achieve this using Java Mapping or XSLT to organize the hierarchy as an Intermediate step prior to writing it to Receiver FCC.

Refer following for similar discussions & approach:

FCC For Hierarchical Structure in Receiver Channel - Process Integration - SCN Wiki

Regards,
Azhar

[Former Member · Accepted solution]

Hi Azhar,

thank you for reply.

I've changed my mapping removing subnodes now is ok.

Fabio