locked
Choosing Unique Values Generically and add respective data in Standard Input RRS feed

  • Question

  • Hi,

    I want to send the unique data by generic checking and adding respective other data in case of Standard (X12) Input 850 Message.

    My Input :

    ISA*00* 00 *ZZ*THEM *ZZ*US 991221*1226*U*00401*000000025*0*T
    GS*PO*THEM*US*19991221*1226*1*X*004010
    ST*850*0001
    BEG*00*NE*3859199838**950727***IBM
    PER*AA*Andrew Carlson*TE*(708) 555-2930
    DTM*002*970523
    PO1*1*93*BX*145.39**CB*KOW-20392-10
    PID*F****Uninterruptible Power System
    PER*AA*Camilla Anderson*TE*(708) 555-2011
    PO1*2*25*EA*35.68**CB*ABX-2001
    PID*F****High Volume Printer Stand
    PER*AA*Miranda Cappelan*TE*(708) 555-1111
    PO1*3*4*PC*2002.91**CB*ABX-2001
    PID*F****Electronics Cabinet Package (56" High)

    PO1*1*2*BX*145.39**CB*KOW-20392-10
    PID*F****Uninterruptible Power System
    PER*AA*Camilla Anderson*TE*(708) 555-2011

    CTT*3
    SE*14*0001
    GE*1*1
    IEA*1*000000025

    My Expected Output :

    <OrderFile>
    <Order>
    <Header>
    <PODate>950727</PODate>
    <PONumber>3859199838</PONumber>
    </Header>

    <LineItems>
    <PONumber>KOW-20392-10</PONumber>
    <Quantity>95</Quantity>
    </LineItems>

    <LineItems>
    <PONumber>ABX-2001</PONumber>
    <Quantity>29</Quantity>
    </LineItems>

    </Order>
    </OrderFile>

    Need mapping link / functoids / XSLT code for this standard input 850 message.

    Need Urgently.

    Thanks & Regards


    Thanks &amp; Best Regards, Siddharth

    Tuesday, September 23, 2014 12:34 PM

All replies

  • Sorry, your question is not very clear.  Are you having a specific problem?
    Tuesday, September 23, 2014 12:46 PM
    Moderator
  • Hi John,

    Actually I need to

    put a unique check on PO1:07 element and need to add the respective PO1:02 element.

    1st PO1:07 = KOW-20392-10

    1st PO1:02 = 93

    2nd PO1:07 = ABX-2001

    2nd PO1:02 = 25

    3rd PO1:07 = ABX-2001

    3rd PO1:02 = 4

    4th PO1:07 = KOW-20392-10

    4th PO1:02 = 2

    Then as PO1:07 for 1st and 4th are same, then in the output there should be one <LineItems> with <PONumber> as KOW-20392-10 and <Quantity> should be added as 93+2 = 95

    Similarly as PO1:07 for 2nd and 3rd are same, then in the output there should be another <LineItems> with <PONumber> as ABX-2001 and <Quantity> should be added as 25+4 = 29

    I want to use the XSLT code but as input is X12 850 standard structure I am not able use the XSLT properly.

    It would be great if you can check the X12 4010 850 message standard structure and let us know how to implement this.

    Thanks & Best Regards


    Thanks &amp; Best Regards, Siddharth

    Friday, September 26, 2014 7:03 AM