Import xml data with many children nodes

[majraj]

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>

[v-yulgu-msft]

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]

Hello

</data>  is missing at the bottom