1

I have a XML data like this

<Root>
<Data>
    <Heading>Time Management</Heading>
    <Field>
        <Description>Prioritizing work</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Phase wise time schedule</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Team Player</Heading>
    <Field>
        <Description>Collaborating with others</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Leadership Quality</Heading>
    <Field>
        <Description>Confident Level</Description>
        <Control>RadioButton</Control>
        <Items>High, Medium, Low</Items>
    </Field>
    <Field>
        <Description>Trust Of Team</Description>
        <Control>RadioButton</Control>
        <Items>High, Medium, Low</Items>
    </Field>
    <Field>
        <Description>Conflict Management</Description>
        <Control>RadioButton</Control>
        <Items>High, Medium, Low</Items>
    </Field>
</Data>
<Data>
    <Heading>Handling Kit</Heading>
    <Field>
        <Description>Safe usage of tools</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Problem Solving Ability</Heading>
    <Field>
        <Description>Finding alternatives</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Managing Independently</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Class room Behaviour</Heading>
    <Field>
        <Description>Discipline</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Interest in work</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Homework completion</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Quality of Work</Heading>
    <Field>
        <Description>Activity completion on time</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Minimizing errors </Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Utilizing available resources</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>
<Data>
    <Heading>Student's field of focus</Heading>
    <Field>
        <Description>Science</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Technology</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Engineering</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
    <Field>
        <Description>Mathematics</Description>
        <Control>RadioButton</Control>
        <Items>Yes,No</Items>
    </Field>
</Data>

This xml is there in each row. I have to make analysis using this data. I tried ExtractValue() function. It takes huge amout of time a i have more than 500 rows (It will increase to thousands).

If i could extract the xml into a table, then i can analyse. Is there any way i can do that ? i cannot use Load XML infile, as i cannot dump into a file first and then take it back. Is there any other way ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.