Data Mapper with pivoted table

[joeytsui]

Hi all,

I have an excel format file which is look like pivot table, and i don’t know how to work with it.

i want to extract the file to a xml data format.
like:

<?xml version="1.0" ?>
<datamining><record>
<_vger_record_id>1058904</_vger_record_id>
<CustomerName>Somewhere</CustomerName>
<PONO>4510241105</PONO>
<ExtraData/>
<detail>
<_vger_record_id>1058905</_vger_record_id>
<DeliveryDate>1/2/2021</DeliveryDate>
<Itemno>Item A</Itemno>
<Qty>24</Qty>
<Itemno>Item B</Itemno>
<Qty>12</Qty>
<ExtraData/>
</detail>
<detail>
<_vger_record_id>1058906</_vger_record_id>
<DeliveryDate>3/2/2021</DeliveryDate>
<Itemno>Item A</Itemno>
<Qty>0</Qty>
<Itemno>Item B</Itemno>
<Qty>0</Qty>
<ExtraData/>
</detail>
<detail>
<_vger_record_id>1058907</_vger_record_id>
<DeliveryDate>5/2/2021</DeliveryDate>
<Itemno>Item A</Itemno>
<Qty>0</Qty>
<Itemno>Item B</Itemno>
<Qty>0</Qty>
<ExtraData/>
</detail>
</record>
</datamining>

[Phil]

The DataMapper only deals with sheets, not with pivot tables.
You should try flattening the pivot table before data mapping it.

See Flatten a pivot table in Excel | The Right Join.

[joeytsui]

thank you very much.