locked
Shred XML data field with Power Query RRS feed

  • Question

  • 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)


    Brent

    Monday, July 13, 2015 3:04 AM

Answers

All replies