Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon,
I am trying to pull in a limited set of alert information from a set of ATOM feeds. i have a web based XML that i can get the list of feeds from, and i am trying to construct a loop that will extract all of the atom feeds into one table. The loop never changes feed addresses as designed with the variable. i have the full script below (all sources are web based, no qlik files needed).
FEEDS:
LOAD
title as FEEDTitle,
countrycode as FEEDCtry,
AutoNumber(countrycode)as CTID,
capAlertFeed,
"capAlertFeed/xml:lang" as FEEDLang,
"link/href" as FEEDLink
FROM [http://meteoalarm.eu/ATOM/root.xml]
(XmlSimple, table is [feed/entry],embedded labels);
let vmaxID = 36;
let vCurrentID = 1;
Do while vCurrentID <= vmaxID
CurrentFeed:
load
capAlertFeed as CurrentFeed1
resident FEEDS
where (CTID = '$(CurrentID)');
let vCurrentFeed = peek('CurrentFeed1');
//loading starts here:
Load
[cap:areaDesc],
[cap:certainty],
[cap:effective],
[cap:event],
[cap:expires],
[cap:geocode],
[cap:msgType],
[cap:onset],
[cap:sent],
[cap:severity],
[cap:status],
[cap:urgency],
[id],
[link],
[published],
[updated]
From
['$(vCurrentFeed)'](xml);
let vCurrentID2 = 1+vCurrentID;
Let vCurrentID = vCurrentID2;
Drop Table CurrentFeed;
Loop;