OL Learn

Data Mapper with pivoted table

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>

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

See https://therightjoin.wordpress.com/2018/09/02/flatten-a-pivot-table-in-excel/#:~:text=In%20order%20to%20make%20the,it%20easier%20to%20explore%20data.

thank you very much.