Load data to one table from multiple RSS feeds

[#1]

I want to load data from these 3 RSS feeds into QV through a loop and variables, and I can't figure out why it isn't working.  I've looked up a ton of community posts, but I'm having trouble adapting them to this data.  It either errors out or loads nothing for everything I've tried.  Can someone help?

(note: I could easily hard code them, but this is just an example & I need to load a lot more than just these)

feed urls:

http://rssfeeds.azcentral.com/phoenix/local

http://rssfeeds.azcentral.com/phoenix/nation

http://rssfeeds.azcentral.com/phoenix/business

load statement:

LOAD origLink,

    title,

    link,

    description,

    pubDate,

    guid,

    encoded,

    [guid/isPermaLink] as isPermaLink,

    [enclosure/url] as url,

    [enclosure/length] as length,

    [enclosure/type] as type,

    'http://rssfeeds.azcentral.com/phoenix/business' as feed 

FROM [http://rssfeeds.azcentral.com/phoenix/business] (XmlSimple, Table is [rss/channel/item]);

[stevedark]

Appreciate that this is an old post, but just in case anyone arrives here looking for an answer, I have recently posted a blog article on doing just this:

https://www.quickintelligence.co.uk/reading-rss-feeds-with-qlik-rest-connector/

Hope it helps someone.

When loading with the REST connector I would always recommend doing the REST load into a temporary table and then doing a RESIDENT load from that. You can then use a CONCATENATE statement when bringing in subsequent tables - or ensure all tables have exactly the same columns.

Hope that helps someone.

Steve