Skip to Content
avatar image
Former Member

Sort incoming XML message

Hi

Is there a standard way in PI to sort the incoming XML message within the message mapping before doing the mapping itself?

The scenario would be an incoming Flat file with header and item data records, and we will be mapping it in PI to create IDOC messages based on the same Header segment. So for the same Header Data I would like to create a single IDOC. But the incoming file would be unsorted, so I would need to sort it first based on the header segment some way.

Ideally, we would like to do all of the mapping in the graphical mapping tool and not use a UDF.

Thanks

Edited by: MxG on Nov 20, 2008 5:04 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 20, 2008 at 10:09 PM

    HI

    Yes you can sort using standard Node function Sort.

    Set the input data to same context and use Sort.

    Thanks

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI

      No we can set context to sender fields only. When it sorted the target parent node and all the source node context is set to parent node then it should be sorted values during mapping.

      Check if you are missing something in this

      Thanks

      Gaurav