Post reply

Extract field containing XML file and load results into a datatable

  • February 3, 2012 at 8:59 am

    #250274

    Hi,

    I was wondering how I can accomplished the following:

    1. Data Field contains an entire XML File

    2. Extract the contents of that field and load to a new datatable

    Thanks in advance

  • February 3, 2012 at 11:26 am

    #1442566

    Based on the very limited information all I can suggest is to look into XQuery syntax.

    A few scenarios with coded solutions can be found at Jacob Sebastians blog.

    If you're looking for a specific solution, you'll need to provide some sample data and your expected result.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 3, 2012 at 11:45 am

    #1442570

    Thanks for the reply:

    The current system is using Info-Path (I haven't seen the code-base at all) and they are caputring user information and putting the data into an XML file that specific file is then loaded to a field (XMLTYPE) within the targeted table. The issue is that you need the data from this XML to x-reference with data from other tables.

    I've never seen this done before. I'd like to create a parser for this XMLTYPE field.

    Thanks,

  • February 3, 2012 at 11:52 am

    #1442575

    There's no parser needed. As stated before, you can use the XQuery syntax to extract the data. Did you have a look at the blog I linked in my previous post?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 4, 2012 at 6:12 am

    #1442741

    I figured it out. Using a type of Extract functionality to retrieve nodes

    Thanks,

  • February 4, 2012 at 6:15 am

    #1442742

    Joe Contreras-290946 (2/4/2012)

    I figured it out. Using a type of Extract functionality to retrieve nodes

    Thanks,

    Would you mind sharing your solution so others may benefit?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply