Biztalk mapper

Viewing 0 reply threads
  • Author
    Posts
    • #18655
      Hi,
      
      I am trying to construct a map but my destination schema have multiple 
      nodes. An example:
      
      First example of my input xml:
      
      <ns0:QueryNode xmlns:ns0=”http://InsuranceMap.schIDE_TMP_REMOTA“>
        <NUM_UTENTE>179884964</NUM_UTENTE>
        <COD_SUBSISTEMA>935601</COD_SUBSISTEMA>
        <SUBSISTEMA>SNS</SUBSISTEMA>
        <NUM_BENEF>179884964</NUM_BENEF>
      </ns0:QueryNode>
      
      if my <NUM_UTENTE> is equal to <NUM_BENEF>
      my output xml looks like this:
      
      <MSG>
        <HL7_XML_MSG>
          <INSURANCE>
            <IN1>
              <IN1_1_ID>1</IN1_1_ID>
              <IN1_2_INSURANCE_PLAN>
                <IN1_2.1_INSURANCE_PLAN_ID>935601</IN1_2.1_INSURANCE_PLAN_ID>
                <IN1_2.2_TEXT>SNS</IN1_2.2_TEXT>           
                <IN1_2.3_NAME_CODING_SYSTEM>SONHO</IN1_2.3_NAME_CODING_SYSTEM>
              </IN1_2_INSURANCE_PLAN>
              <IN1_3_INSURANCE_COMPANY_ID/>
              <IN1_13_PLAN_EXPIRATION_DATE/>     
              <IN1_49_INSUREDS_ID_NUMBER>179884964</IN1_49_INSUREDS_ID_NUMBER>
            </IN1>
          </INSURANCE>
          <INSURANCE>
            <IN1>
              <IN1_1_ID>2</IN1_1_ID>
              <IN1_2_INSURANCE_PLAN>
                <IN1_2.1_INSURANCE_PLAN_ID>935601</IN1_2.1_INSURANCE_PLAN_ID>
                <IN1_2.2_TEXT>SNS</IN1_2.2_TEXT>     
                <IN1_2.3_NAME_CODING_SYSTEM>SONHO</IN1_2.3_NAME_CODING_SYSTEM>
              </IN1_2_INSURANCE_PLAN>
              <IN1_3_INSURANCE_COMPANY_ID/>
              <IN1_13_PLAN_EXPIRATION_DATE/>
              <IN1_49_INSUREDS_ID_NUMBER>179884964</IN1_49_INSUREDS_ID_NUMBER>
            </IN1>
          </INSURANCE>
        </HL7_XML_MSG>
      </MSG>
      
      I have always 2 <INSURANCE>
      
      Second Example, input xml:
      <ns0:QueryNode xmlns:ns0=”http://InsuranceMap.schIDE_TMP_REMOTA“>
        <NUM_UTENTE>179884964</NUM_UTENTE>
        <COD_SUBSISTEMA>111111</COD_SUBSISTEMA>
        <SUBSISTEMA>ADSE</SUBSISTEMA>
        <NUM_BENEF>111222333</NUM_BENEF>
      </ns0:QueryNode>
      
      In this case the <NUM_UTENTE> is different of the <NUM_BENEF>, my output xml 
      file needs to looks like this: 
      
      <MSG>
        <HL7_XML_MSG>
          <INSURANCE>
            <IN1>
              <IN1_1_ID>1</IN1_1_ID>
              <IN1_2_INSURANCE_PLAN>
                <IN1_2.1_INSURANCE_PLAN_ID>111111</IN1_2.1_INSURANCE_PLAN_ID>
                <IN1_2.2_TEXT>ADSE</IN1_2.2_TEXT>
                <IN1_2.3_NAME_CODING_SYSTEM>SONHO</IN1_2.3_NAME_CODING_SYSTEM>
              </IN1_2_INSURANCE_PLAN>
              <IN1_3_INSURANCE_COMPANY_ID/>
              <IN1_13_PLAN_EXPIRATION_DATE/>
              <IN1_49_INSUREDS_ID_NUMBER>111222333</IN1_49_INSUREDS_ID_NUMBER>
            </IN1>
          </INSURANCE>
          <INSURANCE>
            <IN1>
              <IN1_1_ID>2</IN1_1_ID>
              <IN1_2_INSURANCE_PLAN>
                <IN1_2.1_INSURANCE_PLAN_ID>935601</IN1_2.1_INSURANCE_PLAN_ID>
                <IN1_2.2_TEXT>SNS</IN1_2.2_TEXT>          
                <IN1_2.3_NAME_CODING_SYSTEM>SONHO</IN1_2.3_NAME_CODING_SYSTEM>
              </IN1_2_INSURANCE_PLAN>
              <IN1_3_INSURANCE_COMPANY_ID/>
              <IN1_13_PLAN_EXPIRATION_DATE/>
              <IN1_49_INSUREDS_ID_NUMBER>179884964</IN1_49_INSUREDS_ID_NUMBER>
            </IN1>
          </INSURANCE>
        </HL7_XML_MSG>
      </MSG>
      
      Some of this field are constants (<IN1_2.3_NAME_CODING_SYSTEM> …)
      
      if in the schema was possible to have two INSURANCE NODES, i can do this 
      with logical functoids… But i only have one node. Can some one please tell 
      me i to resolve this and if it is possible give an example.
      
      Thanks!
Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.