Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can we read xml files with attribute ? and use attribute in where clause ?
Regards,
Shubhu
Hi Shubhu,
Yes you can read xml files elements/atrributes and apply the where clause.
Cheers,
Shyam
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.