none
Need U-SQL query for XML File

    Question

  • hello all,

    I have IBM watson XML file and I am unable to write the u-sql query for this xml structure can anybody tell me the query for below xml file. I already have xml extensions. 

    XML:

    <?xml version="1.0" encoding="UTF-8"?><Order DocumentType="0001" OrderNo="MYN_AL_000000000000000164_1" CustomerEMailID="NA" SellerOrganizationCode="PUMA_INDIA" EnterpriseCode="PUMA_INDIA" EntryType="MP" OrderType="MYNTRA" OrderDate="2018-05-11T04:30:03.000Z" DraftOrderFlag="N">
    <Extn ExtnMPOrderNo="109577529"/>
    <HeaderCharges>
    <HeaderCharge ChargeAmount="0.0000" ChargeCategory="CHARGE" ChargeName="SHIPPING" Reference="NA" />
    </HeaderCharges>
    <OrderLines>
    <OrderLine PrimeLineNo="1" SubLineNo="1" FulfillmentType="HOME_DELIVERY" ShipNode="" OrderedQty="5">
    <Item ItemID="4057828827803" ItemShortDesc="ENERGIZED Sweat Pants W" ItemDesc="NA" UnitOfMeasure="" />
    <LinePriceInfo IsPriceLocked="Y" ListPrice="0.0000" UnitPrice="1599.0000" /><LineCharges><LineCharge ChargeCategory="DISCOUNT" ChargeName="DISCOUNT" ChargePerLine="0.0000" Reference="NA" /></LineCharges>
    <Extn ExtnCarrier="" ExtnMPSubOrderNo="1100177529"  ExtnKittingFlag="1" ExtnPriorityFlag="N" ExtnVASFlag="Y" ExtnVASDescription="NA" />
    <PersonInfoShipTo FirstName="Gautam" LastName="Gautam" AddressLine1="Mahaveer tola ara13" AddressLine2="Mahaveer tola ara" AddressLine3="10" AddressLine4="NA" EmailID="NA" City="Gautam" State="10" Country="IN" MobilePhone="7903306935" ZipCode="802301" />
    </OrderLine>
    </OrderLines>
    <PaymentMethods>
    <PaymentMethod FirstName="Gautam" LastName="Gautam" PaymentReference1="9999999" PaymentType="COD" >
    <PaymentDetails ChargeType="CHARGE" ProcessedAmount="7995.0" />
    </PaymentMethod>
    </PaymentMethods>
    <PersonInfoBillTo FirstName="Gautam" LastName="Gautam" AddressLine1="Mahaveer tola ara13" AddressLine2="Bhojpur" AddressLine3="10" AddressLine4="NA" EmailID="NA" City="Bhojpur" State="10" Country="IN" MobilePhone="7903306935" ZipCode="802301" />
    <PersonInfoShipTo FirstName="Gautam" LastName="Gautam" AddressLine1="Mahaveer tola ara13" AddressLine2="Mahaveer tola ara" AddressLine3="10" AddressLine4="NA" EmailID="NA" City="Gautam" State="10" Country="IN" MobilePhone="7903306935" ZipCode="802301" />
    </Order>

    Monday, May 21, 2018 9:49 AM

All replies