topic xml where condition in QlikView

xml where condition

Tue, 22 Nov 2011 12:49:56 GMT

Hi,

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

Regards,

Shubhu

Tue, 22 Nov 2011 13:12:10 GMT

Hi Shubhu,

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

Cheers,

Shyam

jagan — Tue, 22 Nov 2011 13:12:27 GMT

Hi,

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

Example:

<books>

</book>

</book>

</book>

</book>

</books>

Load Script:

book:

LOAD

id,

name

WHERE id = 1;

LOAD id,

name

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

Regards,

Jagan.