locked
Create a schema for the OutPut file RRS feed

  • Question

  • I am trying to create a output file schema which should be of the below format.

    MEMBER,1,134,134,Jo, ,Arch,1,S,M
    BENEFIT,1,M,1,89,7,1,1,20110101,20120731,11
    BENEFIT,1,D,2,89,3,11,5,20110101,20120731,16
    MEMBER,14,448,448,Cli,M,Ast,1,M,M
    BENEFIT,14,D,2,89,3,11,5,20170101,17000101,16
    BENEFIT,14,M,1,89,7,1,1,20170101,17000101,11
    BENEFIT,14,M,1,89,7,1,1,20150101,20161231,11

    So in the Flat File schema, should I create two records one for the Member (with one as the Max Occur) and One for Benefit (max occur to unbounded)?

    Am I doing it right

    Wednesday, December 28, 2016 6:03 PM

Answers

  • You will need to add one more level of looping so that Member and Benefit can loop together.

    So, add a new Record Element under Root (you should change that also) called like MemberInfo.

    Then move Member and Benefit under that.

    Wednesday, December 28, 2016 8:44 PM
    Moderator