do while with if statement

[wunderch]

Hi Guys,

I have a problem with do while and an if statement.

I want to load Data from 5 Years ago to today, but on 01.01. the Data should be load from 5 years ago to year(today)-1, because on 01.01. I haven't Data from the actual year.

Example:

LET a=year(today())-5;

if num(month(Today()))=01 and day(today())=01 then

do while a<=year(today())-1;

ELSE

do while a<=year(today());

TEST:

Load

*

from TEST_(a).csv;

LET a=a+1;

Loop

ENDIF;

How can I do this????

Regards Chris

[Frank_Hartmann · Accepted solution]

Maybe like this:

if num(month(Today()))=1 and num(day(today()))=1 then
For a = year(today())-5 to year(today())-1;
TEST$(a):
Load
*, FileName() as Filename
FROM
[Test_$(a).csv];
next a;
ELSE
For b = year(today())-5 to year(today())
TEST$(b):
Load
*, FileName() as Filename
FROM
[Test_$(b).csv];
next b;
endif;

[wunderch]

Hi Frank,

thanks for your quick answer.

Yes this works!

Have a nice day!

Chris

[Frank_Hartmann]

if you want to do it with a do while clause then also try this:

LET a=year(today())-5;
if num(month(Today()))=1 and num(day(today()))=1 then
do while a<=year(today())-1;

TEST:
Load
*,FileName() as Filename
From
[C:\Users\admin\Desktop\Neuer Ordner (5)\Test_$(a).xlsx]
(ooxml, embedded labels, table is Tabelle1);
Let a=$(a)+1;
loop;

ELSE

do while a<=year(today());
TEST:
Load
*,FileName() as Filename
From
[C:\Users\admin\Desktop\Neuer Ordner (5)\Test_$(a).xlsx]
(ooxml, embedded labels, table is Tabelle1);
Let a=$(a)+1;
Loop
ENDIF;