Hi,
I want to use xml as source file for my datafeeds. but i am unable to use it. It is giving error like maximum 48 columns allowed. Can anyone please send me any link or doc in which they have used xml file as source file for data feeds.
Hi,
I want to use xml as source file for my datafeeds. but i am unable to use it. It is giving error like maximum 48 columns allowed. Can anyone please send me any link or doc in which they have used xml file as source file for data feeds.
Hi,
this happens when you don't specify a meaningful repeating element. The repeating element is a XPath-like description of the elements in the XML file you want as rows in the MashZone result set.
If your XML looks like this...
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?> <result> <data> <datarow> <country name="DE">Germany</country> <metric1>934.0</metric1> <metric2>7885.0</metric2> </datarow> <datarow> <country name="US">United States</country> <metric1>122343.0</metric1> <metric2>1225.0</metric2> </datarow> <datarow> <country name="CN">China</country> <metric1>62231.0</metric1> <metric2>13.0</metric2> </datarow> </data> </result>
...a meaningful repeating element could be "/result/data/datarow", which would give you 4 columns (datarow-country, country-name, datarow-metric1 and datarow-metric2) and 3 rows (one each for DE, US and CN) in MashZone.
In short: Each repeating element creates a row in MashZone, each XML content tag or attribute within that repeat element creates a column in MashZone (depending on the configuration of the XML source operator).