For each loop does not work

[chriys1337]

Hi,

I am not sure where my mistake is, but QV script runs through but does not generate the table:

LET vL.Week=20;

For i = right(WeekName(today()),2) to $(vL.Week) // FOR 16 to 20
Selection_Table:
Load
left(WeekName(today()),4) & right(WeekName(today()),2) +IterNo() 
as Selection;
next i

[Anonymous]

where's your reference table?

or do you use autogenerate?

did you try an explicit noconcatenate?

[Anonymous · Accepted solution]

try:

LET vL.Week=20;

For i = right(WeekName(today()),2) to $(vL.Week) // FOR 16 to 20
Selection_Table:
Load
left(WeekName(today()),4) & right(WeekName(today()),2) +$(i)
as Selection AutoGenerate 1;
next i

[chriys1337]

This worked fine, it was the missing reference table. Also it is working with autogenerate, thank you!

SET vL.FutureWeek=right(WeekName(today()),2)+6;

For i = right(WeekName(today()),2) to $(vL.FutureWeek)
Selection_Table:
Load
left(WeekName(today()),4) & (right(WeekName(today()),2)+rowno()-1)
as Selection
AutoGenerate 1 ;
next i

[Anonymous]

yes, you can't do a load on nothing...

... and iterno() only works for LOAD <-> while loops...