help on UDF

[sahithi_moparthi]

Hi,

  I am new to java.In my mapping i have to use one UDF.

My req:

a              b          c           d         E

001         123         001     123       M1 -> one Item

002         321         002    321        M1-> another item

                              001   123        M4->another item

                              001   123        M1-> Suppress

                              001    321       M3 -> Suppress

Like wise i have to check the a and b with c and d and have to create the nodes.

If the a,b are same as c,d  and create M1

if a,b same as c,d and alraedy the M1 exist then need to suppress that node.

Could any one help me in writing the UDF for thi sreq.

[gagandeep_batra]

Hi Santhoshi,

I think you can do this without UDF if i understood right try following logic:

first concat all A,B,C,D then uses sort function

after sort use split by value change and then use collapse context function

May this help:

Regards

Gagan

[sahithi_moparthi]

Hi,

It is not working.Please fidn my str

Conditions:

1.If the DocNum(SQ level) ,Deliver_No(ADRM3) and POSNR,ITEM_NO both are equals pass corersponding MATNR and create one node

2.If we have the same values as above but MATNR is different then create one node at target

3.If we have the same values including MATNR then SUPPRESS that one.

4.SO one Delivery can conatin multiple matreials.

Issue:

I am facing the issue whe trying to pass the incotrem value.

   1.suppose if i have 5 node then i need to pass those many incoterms segment to target.

But the Incoterm occures at SI(DeliverItem) but i have to compare the above conditions and have to pass corrsponding delv and itemno Inco to target.

Ex:

SC-

  SQ-

         MATNR- M1

          Doc_Num- 001           

          POSNR -546

SQ- 

         MATNR- M2

          Doc_Num- 001

          POSNR -546

SQ- 

         MATNR- M3

          Doc_Num- 002

          POSNR -547

SQ- 

         MATNR- M4

          Doc_Num- 002

          POSNR -547

SI-

          ZZ_SI (0--1)

                Inco1 -A

                Inco2-MM

         ADR3

                Delvyno- 001

                Itenno: 546

   ZZ_SI (0--1) 

                Inco1 -B

                Inco2-MM1

              ADR3 

                Delvyno- 002

                Itenno: 547

It cretaes 4 nodes with inIncoterm valeus as  A A B B.

[Former Member]

Hello,

Ur req is not clear paste sample XML input/output format?

Thanks

Amit Srivastava