xml where condition

[#1]

Hi,

Can we read xml files with attribute ? and use attribute in where clause ?

Regards,

Shubhu

[#2]

Hi Shubhu,

Yes you can read xml files elements/atrributes and apply the where clause.

Cheers,

Shyam

[jagan]

Hi,

We can use xml files with attribute and also filter by attribute in where class.

Example:

<books>

    <book id="1">

        <name>Book1</name>

    </book>

    <book id="2">

        <name>Book2</name>

    </book>

    <book id="3">

        <name>Book3</name>

    </book>

    <book id="4">

        <name>Book4</name>

    </book>

</books>

Load Script:

book:

LOAD

    id,

    name

WHERE id = 1;

LOAD id,

    name

FROM test.xml (XmlSimple, Table is [books/book]);

Regards,

Jagan.