Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi dear community,
Can you help me? I want to use a for loop, something like this:
For vYear = year(Start_Date) to Year(End_Date)
Load
Makedate($(vYear), Month(Date), Day(Date) as Date,
Start_Date,
End_Date
Resident myTable;
Next vYear;
This make me an error: the error was occured in For vYear = year(Start_Date) to Year(End_Date)
and I don't know how to resolve this.
Try this
LOAD Date(Start_Date + IterNo() - 1) as Date,
Start_Date,
End_Date
Resident myTable
While Start_Date + IterNo() - 1 <= End_Date;
Try this
LOAD Date(Start_Date + IterNo() - 1) as Date,
Start_Date,
End_Date
Resident myTable
While Start_Date + IterNo() - 1 <= End_Date;
Perfect!
Thank you very much! That works fine!!
😊