XML Node data mapped to Columns
Question asked by Tim Hagan - June 24 at 9:46 PM
Unanswered
Hello. I have an XML file that I am trying to map to either a Excel or SQL table. I need the (Key) to be the column headers and then the (Mean) as the data and the ID would be the (Timestamp).


-<MeanPublic>
<Key>::Measurement.GridMs.TotW</Key>
<Base>1</Base>
<Period>300</Period>
<Mean>20.4</Mean>
<Timestamp>2019-06-23T00:05:00</Timestamp>
</MeanPublic>
-<MeanPublic>
<Key>::Measurement.GridMs.TotVAr</Key>
<Base>1</Base>
<Period>300</Period>
<Mean>-100.24</Mean>
<Timestamp>2019-06-23T00:05:00</Timestamp>
</MeanPublic>
-<CurrentPublic>
<Key>Com Gateway SN: 19015005:1901500558:Measurement.Operation.Health</Key>
<Base>1</Base>
<Period>300</Period>
<Mean>Ok</Mean>
<Timestamp>2019-06-23T00:05:00</Timestamp>
</CurrentPublic>


Looking like:

Timestamp, Measurement.GridMs.TotW, Measurement.GridMs.TotVA
2019-06-23T00:05:00, 20.4, 100.24


Any help would be so appreciated.

Reply to Thread