Solved: Re: Nested for loop not working - Page 2 - Qlik Community

cclayford · ‎2017-11-03

Hi all

I am trying to use a nested for loop in this manner:

But i keep getting this error:

Your help will be greatly appreciated.

Regards,

Christopher.

stabben23 · ‎2017-11-03

If you check Your variables a and b in variable overview, what values do they have?

cclayford · ‎2017-11-03

stabben23 · ‎2017-11-03

ok, so a wont loop, try to delete singlequote in the list. for each a in 586, 591 ..aso

cclayford · ‎2017-11-03

Unfortunately that did not work. Got the same result.

stabben23 · ‎2017-11-03

then delete singlequote around $(a) and still no singlequote in Your list

cclayford · ‎2017-11-03

The single quotes around $(a) and $(b) were already removed. If i add it, then it does not loop at all.

cclayford · ‎2017-11-03

I think it will be easier for you to troubleshoot with the script:

For each a in '586','591','600','594','599','593','590';

For each b in 'Premier League 17/18','Bundesliga 17/18','La Liga 17/18','French Ligue 1 17/18','Eredivisie 17/18','Serie A 2017/18','Scottish Premiership 17/18';

[Tables]:

LOAD

# as [Pos],

Clubs as [Team],

P,

W,

D,

L,

F,

A,

GD,

Points as [Pts],

'League Table' as [Table Type]

FROM

[https://www.statbunker.com/competitions/LeagueTable?comp_id=$(a)]

(html, codepage is 1252, embedded labels, table is [$(b) League table]);

NEXT a;

NEXT b;

stabben23 · ‎2017-11-03

ok, a numeric value in for each should not have any singlequotes and will be expaned without $(a).

text values should have singlequotes around as in b, this should expand With '$(b)'.

As you can see a wont loop for you, b will as it contains Scottish.

cclayford · ‎2017-11-03

Ok, i removed the 'a' and 'b' next to the "NEXT" function. It now loads all the tables, but it gives me errors in between:

Tables << Premier League 17/18 League table 20 Lines fetched