Hello,

I just worked on a simple query to learn how to retrieve a field from a node with a SQL query.

Select PCR.DATA.query('.') AS XMLFragment
,T.c.value('(./text())[1]', 'int') AS Shift
From PCR
Cross Apply DATA.nodes('PCR/Unit/Shift') AS T(c)

It was a great post and works just fine, but I got to wondering how Power Query might handle this task?

I googled for quite some time, but I must have been using the incorrect terms, because I kept getting API references with xml documents.

Is this possible in Power Query? Does anyone have any good links on this subject? (websites, articles, video)?

Not really trying to attempt with this post, but looking for references than anything else.

Thank you,

Brent

I have a table that contains an XML field called data.

  My XML Field (PCR/Unit/Shift)

http://www.jdonnelly.com/2015/01/04/analyzing-bank-file-conversions-xml-data-files-using-power-query-and-powerpivot/

http://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

For my own experience, my mileage with XML files has varied depending on the format of the XML file