none
Biztalk EDI 837P file splitting based on DTP segment RRS feed

  • Question

  • Hi ,

    I need to split one EDI X12 837P  file based on the DTP segment (date of service) in it..one file should be contain the details greater than the particular date and other file should contain lesser than the paticular date. can anyone tell me the process for this ?

    Thanks in advance :)

    rengaraj

    Monday, May 13, 2013 11:46 AM

Answers

  • Create Two Map .

    One which filter records with DTP greater then particular date.

    One which filter records with DTP Smaller then particular date.

    Seperate file into two part using Two Map.

    Regards

    Mohit

    Monday, May 13, 2013 12:01 PM

All replies

  • Create Two Map .

    One which filter records with DTP greater then particular date.

    One which filter records with DTP Smaller then particular date.

    Seperate file into two part using Two Map.

    Regards

    Mohit

    Monday, May 13, 2013 12:01 PM
  • Hi mohit,

    can u explain the process little big?? because am new to biztalk.

    rengaraj

    Tuesday, May 14, 2013 10:11 AM
  • Hi

    Create Receive Location for Receive EDI 837.

    Create Two Map .

    1.if DTP is greater then Date then construct and transform  Message1.

    2.if DTP is Smaller  then Date then construct and transform Message2 .

    Send Message1 and Message2 .

    Regards.

    Tuesday, May 14, 2013 10:39 AM
  • Be careful, Service Date in the 837P is by Service Line not Claim Information so you can have Claims that straddle the date.

    Also, a Map would only be practical if the date is fixed since injecting a parameter into a Map is harder than it needs to be.

    Removing the Service Lines via the DOM in an Orchestration will give you more wiggle room.

    • Proposed as answer by Johns-305MVP Tuesday, May 14, 2013 3:09 PM
    Tuesday, May 14, 2013 3:09 PM
  • Hi 

    and one more help.

    somewhere i have seen use of EDIoverridden component will use to get the control number for ISA which we gave as in input file for to get the same in output .

    can u pls tell me ???

    Thanks :)

    Rengaraj

    Friday, May 17, 2013 3:52 PM