Forum Discussion

majraj's avatar
majraj
New Member
8 years ago

Import xml data with many children nodes

Hello

 

How can i use data modeling tool to get one table from data below ?

Table should contain No,Customer,Item,Quantity

 

Thx

 

Regards

 

 

<data  register="Records" systemversion="1">
 <Record>
  <No>2004001</No>
  <Customer>001</Customer>
  <rows>
   <row rownumber="0">
    <Item>10101</Item>
    <Quantity>10</Quantity>
   </row>
   <row rownumber="1">
    <Item>10102</Item>
    <Quantity>5</Quantity>
   </row>
   <row rownumber="2">
    <Item>10107</Item>
    <Quantity>20</Quantity>
   </row>
   <row rownumber="3">
    <Item>20102</Item>
    <Quantity>1</Quantity>
   </row>
  </rows>
 </Record>
 <Record>
  <No>2004002</No>
  <Customer>002</Customer>
  <rows>
   <row rownumber="0">
    <Item>10104</Item>
    <Quantity>2</Quantity>
   </row>
   <row rownumber="1">
    <Item>10105</Item>
    <Quantity>1</Quantity>
   </row>
  </rows>
 </Record>

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi majraj,

     

    It prompted error message when I tried to import above XML data, please check whether the posted code is complete and correct.

     

    Regards,

    Yuliana Gu

    • majraj's avatar
      majraj
      New Member

      Hello

       

      </data>  is missing at the bottom