Proxy to File scenario- sorting records.

[manoj_khavatkopp]

Hi Experts,

I have a proxt to file scenario where i need to sort the records coming from Proxy with a key field and then map it to the fil structure.

Source and target structure :

<Records>

          <Name>

          <PhoneNo>

          <Doj>

          <Gender>

</Records>

Sample input :

<Records>

          <Name>ABC</Name>

          <PhoneNo>1234<PhoneNO>

          <Doj>2014-01-02</Doj>

          <Gender>F</Gender>

</Records>

<Records>

          <Name>XYZ</Name>

          <PhoneNo>9876<PhoneNO>

          <Doj>2013-12-01</Doj>

          <Gender>M</Gender>

</Records>

<Records>

          <Name>QWE</Name>

          <PhoneNo>8765<PhoneNO>

          <Doj>2015-04-07</Doj>

          <Gender></Gender>

</Records>

I have to sort according to field Doj.

output should be as :

<Records>

          <Name>XYZ</Name>

          <PhoneNo>9876<PhoneNO>

          <Doj>2013-12-01</Doj>

          <Gender>M</Gender>

</Records>

<Records>

          <Name>ABC</Name>

          <PhoneNo>1234<PhoneNO>

          <Doj>2014-01-02</Doj>

          <Gender>F</Gender>

</Records>

<Records>

          <Name>QWE</Name>

          <PhoneNo>8765<PhoneNO>

          <Doj>2015-04-07</Doj>

          <Gender></Gender>

</Records>

if i should apply sort by key function do i need to apply for all the fields ??

can you please tell exactly which and where Message mapping functions  have to be used ?

Thanks,

Manoj

[former_member184720 · Accepted solution]

>>>if i should apply sort by key function do i need to apply for all the fields ??

yes. You might have to apply sort by key for all the fields.

However it should be very simple if you go with xslt (in case you have lot of fields to apply the sort)

You can refer to sample function in the below document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/000ee4d0-be91-2d10-8aaf-ff8045bdd...

>>>can you please tell exactly which and where Message mapping functions  have to be used ?

Please search scn.

Standard Functions in PI 7.0 - Process Integration - SCN Wiki