Repeating Sequences in XML input stage
Posted: Thu Dec 06, 2012 9:46 am
Hi,
I'm working on XML file that has the repeating sequence. Please see below
<?xml version="1.0" encoding="UTF-8"?>
<MEMBER_EXTRACT>
<REC_CNT>1</REC_CNT>
<MEMBER>
<MEMBER_ID>111</MEMBER_ID>
<MEMBER_PHONE>
<PHONE_TYPE_CODE>WORK</PHONE_TYPE_CODE>
<PHONE_TYPE_DESC>Work/Office</PHONE_TYPE_DESC>
<AREA_CODE>111</AREA_CODE>
<PHONE_NBR>1111111</PHONE_NBR>
<EXTN>11111</EXTN>
<PHONE_IS_PRIM_FLAG>0</PHONE_IS_PRIM_FLAG>
<PHONE_DEL_FLAG>0</PHONE_DEL_FLAG>
<PHONE_CREATED>01/15/2010 10:45:03</PHONE_CREATED>
<PHONE_MODIFIED>01/15/2010 10:45:08</PHONE_MODIFIED>
</MEMBER_PHONE>
<MEMBER_PHONE>
<PHONE_TYPE_CODE>HOME</PHONE_TYPE_CODE>
<PHONE_TYPE_DESC>Home</PHONE_TYPE_DESC>
<AREA_CODE>222</AREA_CODE>
<PHONE_NBR>2222222</PHONE_NBR>
<EXTN></EXTN>
<PHONE_IS_PRIM_FLAG>1</PHONE_IS_PRIM_FLAG>
<PHONE_DEL_FLAG>0</PHONE_DEL_FLAG>
<PHONE_CREATED>01/15/2010 10:45:03</PHONE_CREATED>
<PHONE_MODIFIED>01/15/2010 10:45:08</PHONE_MODIFIED>
</MEMBER_PHONE>
</MEMBER>
</MEMBER_EXTRACT>
From above xml I have MEMBER_PHONE as a repeating sequence, when I use XML input stage I'm getting a single output record with only one phone number information i.e the Work phone which is the first sequence and not getting the Home phone information. Is there a way to handle the repeating sequence with out an XML style sheet . If there is a method please let me know.
Thanks,
Somaraju
I'm working on XML file that has the repeating sequence. Please see below
<?xml version="1.0" encoding="UTF-8"?>
<MEMBER_EXTRACT>
<REC_CNT>1</REC_CNT>
<MEMBER>
<MEMBER_ID>111</MEMBER_ID>
<MEMBER_PHONE>
<PHONE_TYPE_CODE>WORK</PHONE_TYPE_CODE>
<PHONE_TYPE_DESC>Work/Office</PHONE_TYPE_DESC>
<AREA_CODE>111</AREA_CODE>
<PHONE_NBR>1111111</PHONE_NBR>
<EXTN>11111</EXTN>
<PHONE_IS_PRIM_FLAG>0</PHONE_IS_PRIM_FLAG>
<PHONE_DEL_FLAG>0</PHONE_DEL_FLAG>
<PHONE_CREATED>01/15/2010 10:45:03</PHONE_CREATED>
<PHONE_MODIFIED>01/15/2010 10:45:08</PHONE_MODIFIED>
</MEMBER_PHONE>
<MEMBER_PHONE>
<PHONE_TYPE_CODE>HOME</PHONE_TYPE_CODE>
<PHONE_TYPE_DESC>Home</PHONE_TYPE_DESC>
<AREA_CODE>222</AREA_CODE>
<PHONE_NBR>2222222</PHONE_NBR>
<EXTN></EXTN>
<PHONE_IS_PRIM_FLAG>1</PHONE_IS_PRIM_FLAG>
<PHONE_DEL_FLAG>0</PHONE_DEL_FLAG>
<PHONE_CREATED>01/15/2010 10:45:03</PHONE_CREATED>
<PHONE_MODIFIED>01/15/2010 10:45:08</PHONE_MODIFIED>
</MEMBER_PHONE>
</MEMBER>
</MEMBER_EXTRACT>
From above xml I have MEMBER_PHONE as a repeating sequence, when I use XML input stage I'm getting a single output record with only one phone number information i.e the Work phone which is the first sequence and not getting the Home phone information. Is there a way to handle the repeating sequence with out an XML style sheet . If there is a method please let me know.
Thanks,
Somaraju