XG

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.

by Helmut Barro
Posted on Wed, 01/09/2013 - 14:09

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).

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock