Group by items

[Former Member]

hello,

Can you tell me how to map these items (by grouping)

ns0:OrdersInput xmlns:ns0="urn:symbol:motorola:integration">

<OrdersRecord>

<Orders>

<ShipSetNo>1 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1407 </PartNum>

</Orders>

<Orders>

<ShipSetNo>1 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1408 </PartNum>

</Orders>

<Orders>

<ShipSetNo>1 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1409 </PartNum>

</Orders>

<Orders>

<ShipSetNo>2 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1410 </PartNum>

</Orders>

<Orders>

<ShipSetNo>2 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1411 </PartNum>

</Orders>

<Orders>

<ShipSetNo>2 </ShipSetNo>

<FcsProdType>FNE</FcsProdType>

<PartNum>ST1412 </PartNum>

</Orders>

<OrdersRecord>

I want to map it to

E1CUCFG SEGMENT="1"><SEMENT><ShipSetNo><1</ShipSetNo<E1CUVAL SEGMENT="1"><PartNum>ST1408 </PartNum></E1CUVAL>

E1CUVAL SEGMENT="1"><PartNum>ST1409 </PartNum></E1CUVAL>

E1CUCFG SEGMENT="1"><SEMENT><ShipSetNo><2</ShipSetNo<E1CUVAL SEGMENT="1"><PartNum>ST1411 </PartNum></E1CUVAL>

E1CUVAL SEGMENT="1"><PartNum>ST1412 </PartNum></E1CUVAL>

Basically , what I want to do is to pick the new value of ship set no and move it to E1CUCFG segment and group all the the patnum with the same shipset no under the E1CUCFG segment in (E1CUVAL segment).

Any help will be appreciated.

Raj---

[Former Member · Accepted solution]

Hi Rajan,

Try this

ShipSetNo(try using all context) -

---

>SplitByValue(ValueChange)-->CollapseContext->SplitByValue(Each Value)--ShipSetNo

PartNumber--

---

\FormatByExample->PartNUmber

ShipSetNo(try using all context) -

---

>SplitByValue(ValueChange)-------/

it will be better to provide solution if u give ur target structure properly.

Thanks,

Maheshwari.

[Former Member]

Hi Rajan,

Try this,

ShipSetNo(Context OrderRecord)->SplitByValue(Value Change)->collapseContex--->E1CUCFG

ShipSetNo(Context OrderRecord)->SplitByValue(Value Change)->collapseContex------

-

---

>SplitByValue(Each Value)--->ShipSetNo

PartNum--

---

\formatByExample-->E1CUVAL

ShipSetNo(Context OrderRecord)->SplitByValue(Value Change)----/

PartNum--

---

\formatByExample-->PartNum

ShipSetNo(Context OrderRecord)->SplitByValue(Value Change)----/

Thanks,

Maheshwari.

[Former Member]

Thanks Maheshwari.

The target structure is part of ORDERS05 idoc (I replaced the charc field with partnumber).

How do I map the root node. Is it OrdersRecord->E1CUFG AND OrdersRecord->E1CUVAL.

I tried your suggestion. unfortuantely I'm finding that the partnumbers of all the first element of Context are coming under the first E1CUFG and nothing is coming for the second E1CUFG segment

i.e

E1CUCFG SEGMENT="1"><SEMENT><ShipSetNo><1</ShipSetNo>

<E1CUVAL SEGMENT="1"><PartNum>ST1408 </PartNum></E1CUVAL>

E1CUVAL SEGMENT="1"><PartNum>ST1410 </PartNum></E1CUVAL>

[Former Member]

Rajan,

Check this claus weblogs which were mentioned on this type of issues:

/people/claus.wallacher/blog/2006/06/29/message-splitting-using-the-graphical-mapping-tool

/people/claus.wallacher/blog/2006/04/17/replication-of-nodes-using-the-graphical-mapping-tool

/people/stefan.grube/blog/2006/01/09/the-use-of-suppress-in-the-xi-30-graphical-mapping-tool

---Satish