GroupBy functionality in SAP PI

[former_member193466]

Hi,

can anyone please explain how can I achieve GroupBy functionality in sap pi mapping.
e.g. : I am recieving below structure

<Details>
  <a>2014-01-26</a>
  <b>TEST</b>
  <c>A10</c>
  <d>950.24</d>
  <e>913</e>
</Details>
<Details>
  <a>2014-01-26</a>
  <b>TEST</b>
  <c>B10</c>
  <d>151.91</d>
  <e>913</e>
</Details>
<Details>
  <a>2014-01-26</a>
  <b>TES</b>
  <c>C10</c>
  <d>189.37</d>
  <e>913</e>
</Details>

Target structure should be :
<Header>
<f>2014-01-26</f>
<g>913</g>
</Header>
<Details>
<h>TES</h>
<i>189.37</i>
</Details>

[iaki_vila · Accepted solution]

Hi,

You can use the function FormatByExample, check this Stefan Grube's blog

Regards.

[gagandeep_batra]

Hi VR

Can you explain how you select only last values ? on what logic?

Regards

GB