3 Replies Latest reply: May 16, 2013 3:48 AM by Magdalena Tammegger RSS

    How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

    Ross Luciano

      Can anyone help me?  I would like to pull in historical and forecast weather data into a QlikView model using Weather Underground's Weather API.  I'm not really a programmer, so not exactly sure how to do it in a QlikView load script, but it looks like it's possible.  I think for a programmer, it would be fairly easy.  They have a free account sign-up located at http://www.wunderground.com/weather/api/ and I have registered so I have my own key I can insert into the code. I'm fairly experienced creating load script from databases and Excel files, but never have done anything pulling from an external source.

       

      For example, I would like to pull in historical weather data for several cities or a table of cities I could choose from.  For this example say I want Lexington, KY, Denver, CO and Green Bay, WI.  In addition to historical, would be really cool to bring in current conditions and forecast, although I think it would be easier for me to follow if each were separate Loads within the script.  I believe all of those are options by looking at the site.

       

      I will greatly appreciate any help from all you expert programmers out there!

       

      Ross