Help on grouping and context handling

[sahithi_moparthi]

Hi,

I have a query on the below Scenario.

<Recordset>
     <Field1>100</Field1>
      <Field1>Rail</Field2>
       <Field1>1</Field3>
</RecordSet>
<Recordset>
     <Field1>101</Field1>
      <Field1>Van</Field2>
       <Field1>2</Field3>
</RecordSet>
<Recordset>
     <Field1>100</Field1>
      <Field1>Car</Field2>
       <Field1>3</Field3>
</RecordSet>

Please find the below query:
1.I have to group based on the field1.So,in the above example i have 3 Recordset,in which 2 have the same value in field1 so i have to group and  need to create one IDOC.
2.In IDOC,i need to repeat the Item segment,which depends on the Field2.As per the above example,i need to cretae 2 Item segments.

Output should be like:

IDOC -1
Header 100
Item   Rail
Item Car

IDOC-2
Header-101
Item-Van

Could any one please help me how to acheive this functionality.

[Former Member]

Hi,

Use the below logic.

Regards

Venkat

[rajasekhar_reddy14]

Try below mapping logic..

Field1--->removecontext--->sort--->splitbyValue(valueChange)--->collapseContext--->IDoc.

                      RecordSet--->removecontext---------------------------->

                                                                                                         ------>formatByExample--->Item.

Field1--->removecontext--->sort--->splitbyValue(valueChange)--->

Set Field1 context to recordset.

[Former Member]

Hi Santhosi,

I think there's two parts to solving this:

• Sort the Recordsets on the values in Field1. This can be done using an xslt mapping (using xsl:sort).
• Create a graphical mapping that makes use of the splitByValue (Value changed) function to create the required output

Hope this helps.

Kind regards,

Koen