Pentaho

 View Only

 Not able to parse xml

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Sukumar DN's profile image
Sukumar DN posted 02-06-2019 04:02

This content was either too long or contained formatting that did not work with our migration. A PDF document is attached that contains the original representation

 

Hi ,Can any one let me know how can we process this below xml .I need the data in tabluar format as below.Start_valid_date, end_valid_date, dew point,wind chill,sustained ... so on in paramaters section2019-02-05T00:00:00-06:00,2019-02-05T01:00:00-06:00,49,null,6,.......I tried giving loop xpath as <dwml> i am getting the single record . Please help us how can I get the complete set of records.XML to be parsed:--------------------------------<dwml xmlns:xsd="http://www.w3.org/2001/XMLSchema <http://www.w3.org/2001/XMLSchema>" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance <http://www.w3.org/2001/XMLSchema-instance>" version="1.0" xsi:noNamespaceSchemaLocation="http://graphical.weather.gov/xml/DWMLgen/schema/DWML.xsd <http://graphical.weather.gov/xml/DWMLgen/schema/DWML.xsd>"> <head>  <product concise-name="tabular-digital" operational-mode="developmental" srsName="WGS 1984"> <creation-date refresh-frequency="PT1H">2019-02-04T20:27:08-06:00</creation-date></product><source>  <production-center>San Angelo, TX</production-center> <credit>https://www.weather.gov/sjt <https://www.weather.gov/sjt></credit><more-information>http://www.nws.noaa.gov/forecasts/xml/ <http://www.nws.noaa.gov/forecasts/xml/></more-information></source></head><data>  <location>  <location-key>point1</location-key> <description>Abilene TX, TX</description><point latitude="32.45" longitude="-99.75"/><city state="TX">Abilene TX</city><height datum="mean sea level">1745</height></location><moreWeatherInformation applicable-location="point1"> http://forecast.weather.gov/MapClick.php?lat=32.45&lon=-99.75&FcstType=digital <http://forecast.weather.gov/MapClick.php?lat=32.45&lon=-99.75&FcstType=digital></moreWeatherInformation><time-layout time-coordinate="local" summarization="none"><layout-key>k-p1h-n1-0</layout-key><start-valid-time>2019-02-05T00:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T01:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T01:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T02:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T02:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T03:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T03:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T04:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T04:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T05:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T05:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T06:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T06:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T07:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T07:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T08:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T08:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T09:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T09:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T10:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T10:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T11:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T11:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T12:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T12:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T13:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T13:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T14:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T14:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T15:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T15:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T16:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T16:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T17:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T17:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T18:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T18:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T19:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T19:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T20:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T20:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T21:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T21:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T22:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T22:00:00-06:00</start-valid-time><end-valid-time>2019-02-05T23:00:00-06:00</end-valid-time><start-valid-time>2019-02-05T23:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T00:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T00:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T01:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T01:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T02:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T02:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T03:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T03:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T04:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T04:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T05:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T05:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T06:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T06:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T07:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T07:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T08:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T08:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T09:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T09:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T10:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T10:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T11:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T11:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T12:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T12:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T13:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T13:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T14:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T14:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T15:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T15:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T16:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T16:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T17:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T17:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T18:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T18:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T19:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T19:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T20:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T20:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T21:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T21:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T22:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T22:00:00-06:00</start-valid-time><end-valid-time>2019-02-06T23:00:00-06:00</end-valid-time><start-valid-time>2019-02-06T23:00:00-06:00</start-valid-time><end-valid-time>2019-02-07T00:00:00-06:00</end-valid-time><start-valid-time>2019-02-07T00:00:00-06:00</start-valid-time><end-valid-time>2019-02-07T01:00:00-06:00</end-valid-time><start-valid-time>2019-02-07T01:00:00-06:00</start-valid-time><end-valid-time>2019-02-07T02:00:00-06:00</end-valid-time><start-valid-time>2019-02-07T02:00:00-06:00</start-valid-time><end-valid-time>2019-02-07T03:00:00-06:00</e...
#Pentaho
#PentahoDataIntegrationPDI
#Kettle
Attachment  View in library
Not able to parse xml 116 KB
Roguen Keller's profile image
Roguen Keller posted 02-07-2019 18:17

Whew! A lot of scrolling in this post to get to the bottom.  Could you possibly post the XML that you're trying to post as an attachment rather than in the message itself. 

It may help provide a clearer understanding around what you're asking and what is your actual data.

Have you started on any kind of a transformation you can share?

Data Conversion's profile image
Data Conversion posted 08-14-2019 23:44
Attachment  View in library
68159.pdf 116 KB

Related Content