Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Proxy to File scenario- sorting records.

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

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question