Loop with Variables

jheasley — Mon, 04 Dec 2017 19:49:32 GMT

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;

topic Loop with Variables in App Development

Loop with Variables