none
USQL script convert nested xml to table

    Question

  • Sample XML; Access convert the below XML to table in few seconds.

     <?xml version="1.0" encoding="utf-8"?>
    <Traders>
      <Trade internalId="12994626436" type="">
        <ReferenceNumbers>
          <ReferenceNumber type="TradeID" isPrimary="true">100028</ReferenceNumber>
        </ReferenceNumbers>
        <Comments>
          <Comment type="SpecialInstructions">Trade Hours: 9:00am - 3:30 pm </Comment>
        </Comments>
      </Trade>
    </Traders>


    Navin.D http://dnavin.wordpress.com





    • Edited by Navind Wednesday, March 7, 2018 12:59 AM
    Friday, March 2, 2018 12:32 AM

All replies

  • I'd be happy to help, but I don't understand you're question.

    Guy

    Friday, March 2, 2018 10:32 PM
  • Hi Guy,

    We loaded the xml file adl, now we want to create the table per xml node using usql. And use it in Powerbi.

    Regards,

    navin


    Navin.D http://dnavin.wordpress.com

    Sunday, March 4, 2018 6:23 AM
  • Thank you for the additional details.  This prior post should help you.  https://stackoverflow.com/questions/34612627/how-to-extract-attribute-values-from-xml-element-using-xml-extractor-in-u-sql 

    You can also find the sample XML extractor here https://github.com/Azure/usql/tree/master/Examples/DataFormats/Microsoft.Analytics.Samples.Formats 

    Monday, March 5, 2018 3:56 PM