none
EDI834 RRS feed

  • Question

  • I am getting the Value of PER from the database

    PER01_2100G__ContactFunctionCode

    PER03_2100G__CommunicationNumberQualifier

    PER04_2100G__CommunicationNumber

    Now i m mapping this to EDI 834 PER Segment

    My problem is when all the three value are null then i dont want to include PER segment.

    Like now in my case when all the values are NULL it just ouputting the segment Like this

    PER

    But i want tht if all the values are NULL it should not output the PER segment

    Monday, November 14, 2011 10:14 PM

Answers

  • Assuming you are setting this in a map, use a functoid to validate that all values exist, if all are null then the output should be false. Map the output from that functoid to the PER segment. The PER segment will not be created if the output from your funtoid is false.  Here is a mapping example.

    • Marked as answer by sriaug Monday, November 14, 2011 11:18 PM
    • Unmarked as answer by sriaug Monday, November 14, 2011 11:29 PM
    • Marked as answer by sriaug Wednesday, November 16, 2011 6:03 PM
    • Unmarked as answer by sriaug Wednesday, November 16, 2011 9:00 PM
    • Marked as answer by sriaug Wednesday, November 16, 2011 9:01 PM
    Monday, November 14, 2011 10:47 PM
  • This thing work for me when i replaced Logical existance with Logical String.


    Thanks Kevin......
    • Marked as answer by sriaug Wednesday, November 16, 2011 6:04 PM
    • Edited by sriaug Wednesday, November 16, 2011 6:06 PM
    Wednesday, November 16, 2011 6:04 PM

All replies

  • Assuming you are setting this in a map, use a functoid to validate that all values exist, if all are null then the output should be false. Map the output from that functoid to the PER segment. The PER segment will not be created if the output from your funtoid is false.  Here is a mapping example.

    • Marked as answer by sriaug Monday, November 14, 2011 11:18 PM
    • Unmarked as answer by sriaug Monday, November 14, 2011 11:29 PM
    • Marked as answer by sriaug Wednesday, November 16, 2011 6:03 PM
    • Unmarked as answer by sriaug Wednesday, November 16, 2011 9:00 PM
    • Marked as answer by sriaug Wednesday, November 16, 2011 9:01 PM
    Monday, November 14, 2011 10:47 PM
  • I tried this method i dont know why but its still giving empty PER segment

    I have one map from PER01 from source to destination also....is tht is the cause of still empty segment

    • Edited by sriaug Monday, November 14, 2011 11:27 PM
    Monday, November 14, 2011 11:25 PM
  • I tried this method i dont know why but its still giving empty PER segment

    I have one map from PER01 from source to destination also....is tht is the cause of still empty segment

    I would suggest that you remove any map from PER -> PER and use the  exists shape on one or more of the PER child elements to determine weather or not to create the CHILD record.

    Otherwise you will continue to have problems.

    Tuesday, November 15, 2011 12:36 AM
  • This thing work for me when i replaced Logical existance with Logical String.


    Thanks Kevin......
    • Marked as answer by sriaug Wednesday, November 16, 2011 6:04 PM
    • Edited by sriaug Wednesday, November 16, 2011 6:06 PM
    Wednesday, November 16, 2011 6:04 PM