Can you build an 856 map in Visual Studio only using functoids and Implied Looping??? RRS feed

  • Question

  • Yes I am trying to create an Inbound 856 map where the output is a Tab Delimited Text file. All is well until I hit the HL*Q level in my SLN Loop. I had an implied loop from my SLN segment to my Looping record in my flat file called the SLI record. Is there anyway I can tell BizTalk that I want each HL*K and HL*Q records to be a part of one SLI ouput record without using scripting? This was made a lot easier in the earlier generation of EDI translators by having a Loop Defined on the X12 document but I get odd output results or omissions when I do a = Functoid of HL03=K or HL03=Q and using that as my Looping Condition. I need this to be either OR. Is this possible? I want to keep this simple and use all Functoids and straight mapping.

    Source X12SLN*000010**I*1*EA****BN*A000002992A505*SN*268435460109610501***TW*000000*TZ*000000***PQ*NW~

    Destination FLat File

    SHP 8087406081 1810 8087406081
    ORD 90107 20110325
    ITM 000010 Samsung SCH-U360MAAVZW SCH-U360MAAVZW 1000.000 EA C
    SLI A0000029CCFFBB 268435460113434811 999999 999999
    SLI 00193246579810243587187367
    SLI A0000029DE663C 268435460114575164

    Mike M
    Sunday, April 24, 2011 4:24 PM

All replies

  • Hi Mike,

    I think you use string concatination functiod at last to combine you output in single at final result to SLI.



    Monday, April 25, 2011 7:18 AM
  • Rajesh:

    Thanks do you mean concatenate both HL loops at the detail level? How is that constructed?

    Mike M
    Monday, April 25, 2011 12:34 PM