2 Replies Latest reply: Nov 22, 2011 8:12 AM by jagan mohan rao appala RSS

    xml where condition

      Hi,

       

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

       

      Regards,

      Shubhu

        • xml where condition

          Hi Shubhu,

           

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

           

          Cheers,

          Shyam

          • xml where condition
            jagan mohan rao appala

            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.