MashZone NextGen Analytics : RAQL Queries : Dataset Paths, Names and Datatypes : Adding Paths to Clarify RAQL Row Detection
Adding Paths to Clarify RAQL Row Detection
If you need to override the default XML elements in a dataset that RAQL treats as rows, you can add a specific path to the elements you need to the variable in the From clause. For this example:
select firstname, lastname, state
from congress/response/legislators/legislator
The variable is congress and /response/legislators/legislator is the path to the element for rows.
The path uses XPath syntax, starting with a slash (/) and separating each level of elements within the hierarchy with a slash. See Load Data with <invoke> for an example of a From clause using paths.
See also Providing Dataset Path and Datatype Information in a Schema for an alternative way to set path information.
Copyright © 2013-2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback