Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

xml where condition

Hi,

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

Regards,

Shubhu

2 Replies
Not applicable

Hi Shubhu,

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

Cheers,

Shyam

jagan
MVP & Luminary
MVP & Luminary

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.