Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk mapper
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
Viewing 0 reply threads
-
AuthorPosts
-
-
December 19, 2007 at 7:18 AM #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!
-
-
AuthorPosts
Viewing 0 reply threads
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.