Skip to Content
avatar image
Former Member

File format

Hello All,

In my scenario,PI is reading a flat file in the below format:

HEADER DETAIL

ITEM DETAIL

HEADER DETAIL

ITEM DETAILS

ITEM DETAILS

==

==

TRAILER

But while writing the same file(one to one mapping) the structure is of the below format:

HEADER DETAIL

HEADER DETAIL

ITEM DETAIL

ITEM DETAIL

ITEM DETAIL

As per my requirement, I want my output format should match with Input format.

Please help me in this regard

Regards,

Moorthy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 27, 2011 at 08:27 AM

    Hi Moorthy,

    Please use thefollowing parameter in your FCC(I am assuming you are getting the problem after FCC):

    xml.recordsetStructureOrder var

    As your incomming file structure is in variable format.

    If you get the correct structure after FCC then i hope there is no need of one to one mapping.

    Regards,

    Harish

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2011 at 09:54 AM

    you might want to try this - /people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 27, 2011 at 10:55 AM

    Changes your receiver structure as

    Record

    -


    Header

    -


    Detail

    Create a Record Node as a parent node to group the Header and Detail, so that Header will be followed by the proper detail

    Edited by: chandra shekhar on Jun 27, 2011 12:58 PM

    Add comment
    10|10000 characters needed characters exceeded